Skip to content

Registered aircraft · 6,349

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-02-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-25-02-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-25-02-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-25-02-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-25-02-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-25-02-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.

N9585UBuhman Kevin H · Marysville, WABuilt 1977 · S/N AA1C0068 N95936Scholey Todd A · Vacaville, CABuilt 1985 · S/N 15285987 N9593SStoffer Aviation LLC · Marion, INS/N 35 N9598AKerr Jerry T · Mount Vernon, WABuilt 1978 · S/N 20A509 N95993Delta State University · Cleveland, MSBuilt 1985 · S/N 15285996 N95995Hagele Aviation LLC · Hillsboro, ORBuilt 1985 · S/N 15285997 N959GTR&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 15282116 N95BJJames William M Jr · Cresson, TXBuilt 1996 · S/N 619 N95BTCampbell Allen B · Meggett, SCBuilt 2010 · S/N M1A2221 N95CWPirani Aaron M · Jacksonville, FLS/N 720 N95JVSarli Adrian Christopher · Jackson, TNBuilt 1982 · S/N 95 N95LJNordin James K · Conroe, TXBuilt 1996 · S/N 001 N95SWMayer Cynthia Lynn · Ponce Inlet, FLBuilt 1978 · S/N 38-78A0107 N9600LDavis Jim F · Poteau, OKS/N AA1B-0100 N9603UAviation Business Corp · Saint Louis, MOBuilt 1977 · S/N AA1C0069 N9604LBlue Grumman Plane LLC · New York, NYS/N AA1B-0104 N9605LStroberger Anthony S · Chandler, AZBuilt 1973 · S/N AA1B-0105 N9605UCook Jacob D · Enid, OKBuilt 1977 · S/N AA1C0070 N96092Florida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1985 · S/N 15286006 N96096Jwa Flight School LLC · Bolingbrook, ILBuilt 1985 · S/N 15286007 N9610SLake A Randy · San Diego, CABuilt 1966 · S/N 265 N9612LSolomon Michael G · Dallas, GABuilt 1973 · S/N AA1B-0112 N9613AHamiter Trace A · Auburn, ALBuilt 1978 · S/N 505 N9613LPederson Patrick D · Cotati, CABuilt 1973 · S/N AA1B0113 N9615LHansen Aviation LLC · Savannah, GABuilt 1973 · S/N AA1B-0115 N9615TEtzel Gregory J · Lafayette, INBuilt 1978 · S/N 38-78A0145 N9617SAnderson David R · Hastings, MNBuilt 1966 · S/N 366 N9618SBradley Christopher · Juneau, AKBuilt 1965 · S/N 385 N9619LPeace Robert L II · Santa Fe, TXBuilt 1943 · S/N AA1B-0119 N9621LDunlay Jerry A · Osage, IAS/N AA1B-0121 N9625UTollini Paul D · Perkasie, PABuilt 1977 · S/N AA1C0076 N9627TRegistration Pending · Sunny Isles Beach, FLRegistration pendingS/N 38-78A0147 N9629LColson Michael D · Alliance, NEBuilt 1973 · S/N AA1B-0129 N9629SSchick Jason · Faulkton, SDS/N 59 N9631LNonemaker Joseph R · Quakertown, PABuilt 1973 · S/N AA1B-0131 N9631SFreedom Aviation Of America LLC · Newcastle, TXBuilt 1966 · S/N 39 N9632UArmstrong Michael · Indianapolis, INBuilt 1977 · S/N AA1C0077 N9633LKessler Garry A · Lansing, WVBuilt 1973 · S/N AA1B-0133 N9634LBeach Donald R · Atlanta, GABuilt 1973 · S/N AA1B-0134 N9635SPake Bradley P · Felton, MNBuilt 1966 · S/N 374 N9639TBasinger Kenneth J · Mcdonough, GABuilt 1978 · S/N 38-78A0149 N963MSMount San Antonio College · Walnut, CABuilt 1982 · S/N 15285655 N9640LRice Mark A · Independence, ORBuilt 1973 · S/N AA1B-0140 N9643URazink Ted · Starbuck, MNBuilt 1977 · S/N AA1C0080 N9644LHaas Larry W · La Cygne, KSBuilt 1973 · S/N AA1B-0144 N9644SClausen Robert G · Argyle, MNS/N 391 N9644UBrannan James E · Fresno, CABuilt 1977 · S/N AA1C0081 N9645UKiebke Heather A · Detroit Lakes, MNFirst renewal noticeBuilt 1977 · S/N AA1C0083 N9647SGarrett Flying Service · Danbury, TXS/N 394 N9648USmith Edward T · Black Diamond, WABuilt 1977 · S/N AA1C0085

Back to AD 80-25-02 R2