Skip to content

Registered aircraft · 40,471

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N9540LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276574 N9540WCarter Brian A · Paragould, ARS/N 28-22970 N95418Selleck Stephen P · Colton, CABuilt 1969 · S/N 28-25936 N95419Underwood William · Fargo, NDBuilt 1969 · S/N 28-25937 N9541KElliott Thomas W · Sarona, WIBuilt 1976 · S/N 28-7625183 N95420Registration Pending · Easton, PARegistration pendingS/N 28-25938 N95422Chimera Air Inc · Maumee, OHBuilt 1969 · S/N 28-25940 N95423Fullerton Alan D · La Crosse, WIBuilt 1969 · S/N 28-25941 N95424Air69 LLC · Kaiser, MOBuilt 1969 · S/N 28-25942 N95426Morten Jesse L · Larimore, NDBuilt 1969 · S/N 28-25944 N95427Mahoney Christopher P · Quakertown, PAS/N 28-25945 N9542HAbusham Hamed M · Upland, CABuilt 1975 · S/N 17266215 N95436Dawson Danny L · Clay, WVBuilt 1969 · S/N 28-25951 N95437Howard Bruce A · Santa Fe, NMBuilt 1969 · S/N 28-25952 N95438Jordan Kenneth R · Wake Forest, NCBuilt 1969 · S/N 28-25953 N9543HGonzalez-Rio Jesus A · Big Pine Key, FLBuilt 1975 · S/N 17266216 N9543JKool Wings Leasing LLC · Indianapolis, INBuilt 1966 · S/N 28-3672 N9543L10 Skies LLC · Rockport, TXBuilt 1974 · S/N AA5-0605 N9543WStryker Kevin · Ben Wheeler, TXBuilt 1967 · S/N 28-22974 N95447Swartzendruber Rebecca A · Bay Port, MIBuilt 1969 · S/N 28-25959 N9544CJones Michael Jay · Schaumburg, ILBuilt 1966 · S/N 28-3614 N9544DPhilpott Stuart L · Taylorsville, KYBuilt 1958 · S/N 22-6461 N9544HSouthern Aero LLC · Homestead, FLBuilt 1975 · S/N 17266217 N9544LFortnight Aviation LLC · Philadelphia, PAFirst renewal noticeBuilt 1974 · S/N AA5-0543 N9544WStrawn Randy A · Atlanta, TXBuilt 1967 · S/N 28-22975 N95450Piper Aire LLC · Shell Knob, MOBuilt 1969 · S/N 28-25963 N95454Butler Byron D · Acworth, GABuilt 1969 · S/N 28-25968 N95455Juszkiewicz Jack · El Paso, TXBuilt 1969 · S/N 28-25969 N95459Folsom James · Lawrenceburg, KYBuilt 1969 · S/N 28-25970 N9545BSunrise Aero Inc · Ocala, FLBuilt 1981 · S/N 172RG0870 N9545DFaught Jeffrey R · Bismarck, NDBuilt 1958 · S/N 22-6462 N9545LMoore Walter Robert · Bradentone, FLBuilt 1974 · S/N AA5-0655 N9545WBouthillier Mark W · Tonawanda, NYBuilt 1967 · S/N 28-22976 N95461Bradford Murvin L · Hensley, ARS/N 28-25971 N95463Licata Paul Z · Mexico, MOBuilt 1969 · S/N 28-25704 N9546DTripacer Leasing LLC · Lauderhill, FLBuilt 1958 · S/N 22-6463 N9546HMiller Dale L · Bozeman, MTBuilt 1975 · S/N 17266219 N9546WSale Reported · Van Nuys, CASale reportedBuilt 1967 · S/N 28-22978 N95471Herrington Herbert A · Gallatin, TNBuilt 1969 · S/N 28-25452 N95473Bohling Anthony W · Auburn, NEBuilt 1969 · S/N 28-25981 N95476Bollinger Aaron · Norfolk, VABuilt 1969 · S/N 28-25985 N95477Wills Thomas J · Plainfield, ILBuilt 1969 · S/N 28-25986 N95479Wilson Scott E · Fostoria, OHBuilt 1969 · S/N 28-25988 N9547DStoltz Michael A · Portland, ORS/N 22-6464 N9547JFranz Stanley · Yakima, WABuilt 1966 · S/N 28-3676 N9547KAviles Hector J · Rancho Cucamonga, CAS/N 28-7615211 N9547LCivil Air Patrol · Maxwell Afb, ALBuilt 1986 · S/N 17276575 N95481North Texas Aeronautics LLC · Fort Worth, TXBuilt 1969 · S/N 28-25989 N9548JMulder Timothy D · Shafter, CABuilt 1966 · S/N 28-3677 N9549HBenson Edward A · San Antonio, TXBuilt 1975 · S/N 17266221

Back to AD 80-04-03 R2