Skip to content

Registered aircraft · 56,578

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N222BKDeralex Airways LLC · Miami, FLS/N 17272887 N222BVBb Air LLC · Chesapeake, VABuilt 1975 · S/N 17264997 N222CTMorency Richard · Houston, TXBuilt 1974 · S/N 18263068 N222DCTextron Aviation Inc · Wichita, KSS/N 18283364 N222ERGjg Air LLC · Amarillo, TXBuilt 1975 · S/N 18263978 N222FDKent State University · Stow, OHBuilt 1968 · S/N 15068498 N222FFReagan John · Knippa, TXS/N 18253725 N222HERound Engine Aero · Nashville, MIBuilt 1978 · S/N 17271191 N222JHRegistered aircraftBuilt 1974 · S/N 18263066 N222LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2001 · S/N 172S8919 N222LJDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 33701764 N222LSLj Bickford Companies LLC · Wasilla, AKBuilt 1972 · S/N U206-01751 N222MHJones Jimmy N · Bremond, TXBuilt 1972 · S/N U20601931 N222MTJw182 LLC · Kalispell, MTBuilt 1998 · S/N 18280108 N222NYCivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276473 N222PAFrank Eric A · East Troy, WIBuilt 1976 · S/N 15078669 N222PXRegistered aircraftBuilt 1976 · S/N 18265157 N222QLindeen Karen D · Anchorage, AKS/N 18257622 N222QAKlopotek Jerome P · Orangevale, CABuilt 1969 · S/N 15070543 N222SADenny Robert C · Fort Myers, FLS/N 15078576 N222SBFuglestad Jon T · Anchorage, AKBuilt 1953 · S/N 30360 N222SGPacific Aviation Aircraft Management Inc · Fresno, CAS/N 210-64410 N222SJTriple Deuce LLC · Harrisonville, MOBuilt 1972 · S/N 21059732 N222TADeschene Michael R · Westminster, CABuilt 1968 · S/N 15069729 N222TKMachowicz Mark M · Eastpointe, MIBuilt 1967 · S/N 18257973 N222TXJ M Williams LLC · Stockton, CABuilt 1957 · S/N 29976 N222USTicoair LLC · Wilmington, DEBuilt 1979 · S/N 17273491 N222VWCool Beans LLC · Newtown, PAS/N 18280085 N222WFBailey Steve · Chehalis, WABuilt 1963 · S/N 205-0220 N222WKSchellhorn Friedrick · Harxheim/MainzS/N 337-0696 N222WTLopes Jeremy B · Peoria, AZBuilt 1952 · S/N 20372 N222XLFox Jeffery R · Spooner, WIBuilt 1981 · S/N 18504278 N222XMSchlasinger Larry DBA · Chetek, WIBuilt 1998 · S/N 18280119 N22304Berry Dewey R · Lexington, SCBuilt 1968 · S/N 15068204 N22305Arend James E · Mesa, AZS/N 15068205 N22307Martin David O · West Mifflin, PABuilt 1968 · S/N 15068207 N2230898x LLC · Caddo Mills, TXBuilt 1968 · S/N 15068208 N2230CHendricks Construction LLC · Phoenix, AZS/N 30530 N2230DHendricks Construction LLC · Phoenix, AZBuilt 1976 · S/N 18503053 N2230JCragg Gordon E · Georgetown, TXS/N 15065430 N2230WJac & Phill Corp · San Ysidro, CAS/N 17250077 N22310Tackett Eric · Huntington, INBuilt 1968 · S/N 15068210 N22318Reggie Denis A Jr · Marietta, GABuilt 1968 · S/N 15068214 N2231DFisher Air LLC · Cardington, OHBuilt 1952 · S/N 20383 N2231EState Of Iowa · Des Moines, IABuilt 2007 · S/N 18281924 N2231FSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 18281925 N2231GKelly Richard · Ogdensburg, NYS/N 51531 N2231THewitt David E · Newcastle, MEBuilt 1968 · S/N 185-1383 N22325Marlee B Thomas · Tolar, TXBuilt 1968 · S/N 15068216 N22329Guernsey G R · Belen, NMBuilt 1968 · S/N 15068219

Back to AD 79-10-14 R1