Skip to content

Registered aircraft · 25,370

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-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N35792Drerup Henry J · Sebastopol, CAS/N 17256964 N35795N35795 LLC · Fredericksburg, TXBuilt 1968 · S/N 17256965 N35798Big Sky Aviation LLC · Massillon, OHBuilt 1968 · S/N 17256967 N35799Huebner Otto · Bolingbrook, ILS/N 17256968 N3579NPorter Gary · Oregonia, OHBuilt 1967 · S/N 680104 N35801Perkins Richard D · East Otto, NYBuilt 1968 · S/N 17256970 N35802Boeing Employees Flying Association Inc · Ridley Park, PAS/N 17256971 N3580QSale Reported · Boise, IDSale reportedBuilt 1973 · S/N 17261680 N35810Mcintosh Aaron · Caldwell, TXBuilt 1968 · S/N 17256976 N35813Davis Daniel E · Doniphan, MOBuilt 1968 · S/N 17256978 N35815Cm3 LLC · North Las Vegas, NVBuilt 1968 · S/N 17256979 N3581QQuantie Harold G · Locust Grove, OKBuilt 1973 · S/N 17261681 N35821Coachair Inc · Groveland, CABuilt 1976 · S/N 177RG1056 N35833Williams David Wayne · Ivins, UTBuilt 1976 · S/N 177RG1057 N35849Gilliam Robert L · Islamorada, FLBuilt 1976 · S/N 177RG1060 N35850Willke Ronald S · Edgewood, TXBuilt 1976 · S/N 177RG1061 N35852Taylor Bruce D · Cedar Rapids, IAFirst renewal noticeS/N 177RG1062 N35858Watkins Rickar D · Roseburg, ORBuilt 1976 · S/N 177RG1063 N3585QLerner Daniel A · East Durham, NYBuilt 1973 · S/N 17261685 N35866Terry Kayla · Moulton, ALBuilt 1976 · S/N 177RG1065 N35869Cardinal Flyers LLC · Moriches, NYBuilt 1976 · S/N 177RG1067 N35872Kurtz David Lee · Cordele, GABuilt 1976 · S/N 177RG1068 N35879Aldrich Brad · Driftwood, TXBuilt 1976 · S/N 177RG1069 N3587LVanatta J Dennis · Faribault, MNBuilt 1978 · S/N 0809 N3587QBerger Donald D · Ilwaco, WABuilt 1973 · S/N 17261687 N3587XFlynn Sean C · Torrance, CABuilt 1968 · S/N 680156 N35884Dake Tech Consulting Inc · San Dimas, CAS/N 177RG1070 N3589QHalfpap Rodney J · Quincy, ILBuilt 1973 · S/N 17261689 N358WGenco Holdings LLC Series A · Corpus Christi, TXBuilt 1966 · S/N 3417 N35905Morgan George Scott · Litchfield Park, AZBuilt 1976 · S/N 177RG1074 N35913Allen John A · Hollister, MOBuilt 1976 · S/N 177RG1076 N35914Dunn Meghan Elizabeth · Mckinney, TXBuilt 1976 · S/N 177RG1077 N3591FWolfe Robert G · West Columbia, SCBuilt 1970 · S/N 17259225 N3591NPeperuka LLC · Olympia, WABuilt 1967 · S/N 680108 N3592QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1973 · S/N 17261692 N3592XBryant David Wayne · Ada, OKBuilt 1968 · S/N 680161 N35936Doncar LLC · Baden, PABuilt 1976 · S/N 177RG1081 N35939Aarons Daniel A · Berkeley, CABuilt 1976 · S/N 177RG1082 N3593FEakin Robert C · Franklin, PABuilt 1970 · S/N 17259400 N3593QKettunen Alan C · Ashtabula, OHBuilt 1973 · S/N 17261693 N35942Schlichting Mark A · Newborn, GABuilt 1976 · S/N 177RG1083 N3594QGribble Ted A · Paris, TXBuilt 1973 · S/N 17261694 N35976Shoemaker Calvin D · Los Angeles, CAFirst renewal noticeBuilt 1976 · S/N 177RG1087 N3597EBlue Bird Aero Club Inc · Bonne Terre, MOBuilt 1978 · S/N 17271601 N3599HSitter Duane A · Hayward, CABuilt 1977 · S/N 20-1238 N359ACRunde Warren N · Concord, NHBuilt 2009 · S/N 1454-2009 N359ALTyson Aviation LLC · Sherrills Ford, NCBuilt 1973 · S/N 17262020 N359BDHoffman Brian T · Flower Mound, TXBuilt 1980 · S/N 21064054 N359CAFly Inverted LLC · Brighton, MIBuilt 2005 · S/N 997-2005 N35BHSkylane Ventures LLC · Charlotte, NCBuilt 1979 · S/N R18201050

Back to AD 80-25-07 R1