Skip to content

Registered aircraft · 40,395

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-03-R2') 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-03-R2') 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-03-R2')
    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-03-R2')
  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-03-R2')
  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-03-R2')
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.

N212ANCalifornia In Nice Inc · San Jose, CABuilt 1981 · S/N 17274432 N212BGRegistered aircraftBuilt 1980 · S/N 172RG0195 N212CANichols Larry W · Leavenworth, WAS/N 18-7809133 N212CKSkymates Inc · Grand Prairie, TXBuilt 1979 · S/N 44-7995294 N212FMooney Daniel V · Malvern, PABuilt 1971 · S/N 28-7205015 N212LBLysogorski Edward P · Bridgeport, MIS/N 20463 N212SFCrowder Alan L · Madison, GABuilt 1960 · S/N 212 N212TMSchuldt Scott A · North Little Rock, ARBuilt 1968 · S/N 17701004 N2130CDurrett Bentley K · Rusk, TXS/N 28-7916132 N2130JEarly Bird Aviation LLC · Rillito, AZBuilt 1978 · S/N 28-7990214 N2130RAscend Aviation LLC · Ira, MIBuilt 1969 · S/N 28-5466 N2130WUnusual Attitudes Flying Club Inc · Mount Vernon, MOBuilt 1974 · S/N M-1505 N21318Raw Racing Inc · Puyallup, WABuilt 1978 · S/N 44-7995046 N2131JAllen Harvey · Elfrida, AZBuilt 1978 · S/N 28-7990215 N2131WRussek Rick · Cave Creek, AZBuilt 1974 · S/N M-1506 N21320Diehl Rodney L Trustee · San Jose, CABuilt 1974 · S/N 17263929 N21321Bell Robert A · Las Vegas, NVBuilt 1974 · S/N 17263930 N21323A2t Guys Aviation LLC · Williamston, MIBuilt 1978 · S/N 28-7916033 N21329Propeller Enterprises LLC · Gilbert, AZBuilt 1974 · S/N 17263931 N2132JHolley William M · Rock Port, MOBuilt 1978 · S/N 28-7990216 N2132TMatejcek Lina M · Owatonna, MNBuilt 1971 · S/N 28-7125448 N2133JHoosier Aviation LLC · Terre Haute, INBuilt 1978 · S/N 28-7990217 N21347Kessler Frank J Jr · Gallatin, TNBuilt 1974 · S/N 17263933 N2134DRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1978 · S/N 28-7916144 N2134ERice Larry Anthony Trustee · Yucaipa, CABuilt 1978 · S/N 28-7990180 N2134JMcmahan Michael Anthony · Dunwoody, GABuilt 1978 · S/N 28-7990218 N2134RVanek Peter · Sedona, AZBuilt 1969 · S/N 28-5467 N2134WJustison David L · Hillsboro, ILBuilt 1974 · S/N M-1508 N21351Midwest Flying Service LLC · Wilmington, DEBuilt 1974 · S/N 17263934 N2135BMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7916110 N2135FMark Alan Bennett · Trinidad, COS/N 28-7990188 N21360Weede Roger H · Dubois, WYS/N 17263935 N2136JHanus John E · North Kingstown, RIBuilt 1978 · S/N 28-7990219 N2136MWashington Israel · Cincinnati, OHBuilt 1977 · S/N 28-7816253 N2136YW Tech Consulting Inc · Wilmington, DEBuilt 1979 · S/N 28-7916368 N21374Stratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263938 N2137JAdverse Yaw LLC · Milford, CTBuilt 1978 · S/N 28-7916205 N2137TWatson Jay C · Midland, TXBuilt 1971 · S/N 28-7105160 N21389Registration Pending · Waldo, WIRegistration pendingBuilt 1974 · S/N 17263942 N2138PRedwood Barry Lindon · Forest, VABuilt 1956 · S/N 23-729 N2139JHotung Lisa M · Amherst, NYBuilt 1978 · S/N 28-7990220 N2139WRegistration Pending · Lake Worth, FLRegistration pendingBuilt 1974 · S/N M-1509 N213AMNorton Cole R · Marion, IAS/N 559-73 N213CBSkymates Inc · Wilmington, DEBuilt 2002 · S/N 4496147 N213MBNational Tax Relief Inc · Riverside, CAS/N 17702282 N21403Bering Capital LLC · Anchorage, AKBuilt 1974 · S/N 17263944 N2140JHardin County Aviation LLC · Kountze, TXBuilt 1975 · S/N 17265018 N2140RStidham Stephen A · North Pole, AKBuilt 1989 · S/N 01 N2140TCupples Thomas Joseph · San Marcos, CABuilt 1971 · S/N 287105162 N2140VSidhu Harish · Anaheim, CABuilt 1979 · S/N 28-7990340

Back to AD 79-10-03 R2