Skip to content

Registered aircraft · 40,396

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.

N5624GFoothill Aircraft Sales & Service · Upland, CABuilt 1979 · S/N 17273563 N56256Flying Bears Aviation LLC · Wilmington, DEBuilt 1973 · S/N 28-7305559 N5625QFly High Aviation LLC · Margate City, NJBuilt 1965 · S/N 3011 N5625USkorina Air LLC · Walla Walla, WABuilt 1969 · S/N 28-26421 N5626LMw Aviators LLC · Olathe, KSBuilt 1972 · S/N AA5-0226 N5626UFly Around Alaska LLC · Palmer, AKBuilt 1969 · S/N 28-26423 N5626WMiller Andy · Marana, AZBuilt 1962 · S/N 28-769 N5627FFolger Alfred J · Columbia, SCBuilt 1976 · S/N 28-7715144 N5627UMcelhannon Susan L · Athens, GABuilt 1969 · S/N 28-26422 N5627WSavio Stefan V · Trophy Club, TXBuilt 1962 · S/N 28-772 N56280Briggs Samuel K · Portland, ORBuilt 1973 · S/N 28-7325597 N56281Lewis Nathan Timothy · Hayden, IDS/N 28-7325598 N56282Kowatra Anil K · Lilburn, GAS/N 28-7325601 N56288Cole Douglas W · Kennewick, WAS/N 28-7325604 N56289Butler Stephen P · Ossian, INBuilt 1973 · S/N 28-7305564 N5628FHobbs Jason · Saint Francisville, LABuilt 1976 · S/N 28-7715145 N5628WB & D Aviators LLC · Bremen, INBuilt 1962 · S/N 28-773 N5629WLawrence Michael · Eden Prairie, MNBuilt 1962 · S/N 28-774 N562MAMorrison Richard L Trustee · Canyon Lake, TXBuilt 2000 · S/N 2062 N562MMStarworld International Ltd · Long Beach, CABuilt 1975 · S/N AA5B-0049 N562PUSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 2000 · S/N 2842104 N562PWWaters Peter M · Baltimore, MDBuilt 1988 · S/N 967 N5631EN141ns LLC · Lantana, FLS/N 17271906 N5631QBayette Andrew · Calhan, COBuilt 1965 · S/N 3014 N5631UTejada Emilia P · Oakland Park, FLS/N 28-26427 N56324De Melo Marcelo Ramos · Vinton, VABuilt 1973 · S/N 287325609 N56325Glaser John · Merritt Island, FLBuilt 1973 · S/N 28-7305570 N5632USale Reported · Montgomery, ALSale reportedBuilt 1969 · S/N 28-26428 N5633PPride Lawrence E · Poway, CABuilt 1959 · S/N 24-703 N5633QKeene John D · Spotsylvania, VABuilt 1965 · S/N 3015 N5633UStaples Clint B · Glen Rose, TXBuilt 1979 · S/N 8003C N5633WWenzel Mark B · Algona, IABuilt 1962 · S/N 28-779 N56343R&T Wings LLC · Lewes, DES/N 28-7325612 N56344Rogers Steve M · Brenham, TXBuilt 1973 · S/N 28-7305574 N5634PWaters George A · Oklahoma City, OKBuilt 1959 · S/N 24-704 N5634SSmb Air Inc · Crescent Springs, KYBuilt 1979 · S/N 8004C N5634WEagle Vision LLC · Hamer, IDBuilt 1962 · S/N 28-781 N56350Aerospace Technology Group Inc · Temecula, CABuilt 1973 · S/N 28-7325613 N5635DZuber Gary D · Culver, ORBuilt 1979 · S/N 8006C N5635ECircle W Flying Club Inc · Creighton, PABuilt 1978 · S/N 17271908 N56363Romzick Peter G · Oxford, MIBuilt 1973 · S/N 28-73-25618 N5636PBarley Austin D · Red Lion, PABuilt 1959 · S/N 24-706 N5636QKelly Thomas J · Henderson, TXBuilt 1965 · S/N 674 N5636UMontie Michael · Fairview Park, OHBuilt 1969 · S/N 28-26432 N5636WWatkins Micah · Queen Creek, AZBuilt 1962 · S/N 28-783 N5637MAmelia Reid Aviation LLC · San Jose, CABuilt 1980 · S/N 8008C N5637UCurtis Alex K · Winnemucca, NVBuilt 1969 · S/N 28-26433 N56380Zimin Carl E · Naknek, AKBuilt 1973 · S/N 287325620 N56382Risley Air LLC · Myrtle Beach, SCBuilt 1973 · S/N 287305580 N56387Prentice Robert D · Ripon, WIBuilt 1973 · S/N 287305584

Back to AD 79-10-03 R2