Skip to content

Registered aircraft · 25,368

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.

N9639TBasinger Kenneth J · Mcdonough, GABuilt 1978 · S/N 38-78A0149 N963AYStark Truss Co Inc · Canton, OHBuilt 1982 · S/N R18201908 N963EAEcho Alpha Aero LLC · Saint Petersburg, FLBuilt 1962 · S/N 2256 N963KMMiller Karl E Trustee · Chandler, AZBuilt 1974 · S/N 17264198 N963MSMount San Antonio College · Walnut, CABuilt 1982 · S/N 15285655 N963TTAmerican Capital Aviation LLC · Kalispell, MTBuilt 2020 · S/N 1189-2020 N963WAChase Kenneth C Jr · Rochester, MNS/N 15282882 N9640HCorriher Mark B · Mocksville, NCBuilt 1975 · S/N 17266287 N9640MDavis Psychological Services Pc · Grinnell, IABuilt 1966 · S/N 670217 N9640SFrancis James E · King City, CABuilt 1966 · S/N 6 N9640VN9640v LLC · Ann Arbor, MIS/N 17264420 N9641HBarton Alva L · Hollister, CABuilt 1975 · S/N 17266288 N9641QBhairavi Aviation LLC · Santa Clarita, CABuilt 1975 · S/N 17265725 N9641VRink Douglas B · Woolwich, MEBuilt 1974 · S/N 17264421 N9642STaylor Jonathan K II · Granbury, TXBuilt 1966 · S/N 3 N9643HMor Aviation N9643h LLC · Gaithersburg, MDBuilt 1975 · S/N 17266290 N9643MExquisite Aviation Inc · Coachella, CABuilt 1966 · S/N 670220 N9643QLeading Edge Flight Academy LLC · Bend, ORBuilt 1975 · S/N 17265727 N9643STurner Nathan D · Nenana, AKFirst renewal noticeBuilt 1966 · S/N 20 N9643VBrazos Valley Flight Services LLC · College Station, TXBuilt 1974 · S/N 17264423 N9644MBurley Joseph D · Fayetteville, GABuilt 1966 · S/N 670221 N9644QSkyhawks Inc · Chippewa Falls, WIBuilt 1975 · S/N 17265728 N9644SClausen Robert G · Argyle, MNS/N 391 N9645HSantiago Diana L · Juana Diaz, PRBuilt 1975 · S/N 17266292 N9645VOak Ridge Flyers Inc · Oak Ridge, TNBuilt 1974 · S/N 17264425 N9646BN9646b LLC · Wilmington, DEBuilt 1981 · S/N 172RG0942 N9647BLakewood Investments LLC · Victorville, CAS/N 172RG0943 N9647MSoaring Eagle Flying Club · Midland, MIBuilt 1966 · S/N 670224 N9647QKaeni Law Group Inc · Santa Ana, CABuilt 1975 · S/N 17265731 N9647SGarrett Flying Service · Danbury, TXS/N 394 N9648HSaunders Larry F · Sulphur Springs, ARBuilt 1975 · S/N 17266294 N9648MN9648m LLC · Louisville, KYBuilt 1967 · S/N 670225 N9648QGreen Bay Flying Club Inc · Krakow, WIBuilt 1975 · S/N 17265732 N9648VGrove Kaylene · San Diego, CABuilt 1974 · S/N 17264428 N96493Smtm Holdings Inc · Wilmington, DES/N 17276080 N9649BGoebel Christian E · Luray, VABuilt 1981 · S/N 172RG0945 N9649SHowell Alice R · Bainbridge, GAS/N 396 N9649VLagorce Victor X · Owasso, OKBuilt 1974 · S/N 17264429 N964AAFlorida Flight Training Center Inc · Venice, FLBuilt 1978 · S/N 17271084 N964JCIceman Air LLC · Stafford, VABuilt 1976 · S/N 22-1355 N964SEGray Luke Francis · San Bruno, CABuilt 2004 · S/N 964-2004 N96503Miravete Paul Trustee · Saint George, UTBuilt 1983 · S/N 17276081 N9650QVon Graff Kurt · Pennington, NJBuilt 1975 · S/N 17265734 N9650VPittman Michael Sr · Chandler, AZBuilt 1974 · S/N 17264430 N9651TPilot Pros Inc · Miami, FLBuilt 1978 · S/N 38-78A0151 N9651VHussain Mahmoud Taimour Said · Miami, FLBuilt 1974 · S/N 17264431 N9652MManna Farms Inc · Sherwood, NDS/N 670229 N9652VBrown Keno · Athens, TXBuilt 1974 · S/N 17264432 N9653BSd Office Supplies & Furniture Rentals LLC · Chula Vista, CABuilt 1981 · S/N 172RG0946 N9653QMikeska Rudy L · Taylor, TXBuilt 1975 · S/N 17265737

Back to AD 80-25-07 R1