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.

N9738MVurlumis George A · Pocono Lake, PABuilt 1967 · S/N 670032 N973BWBattle Flag Inc · Wilmington, DEBuilt 1997 · S/N 1361-97 N9741MPeterson Bradley A · Savoy, ILBuilt 1967 · S/N 670035 N9741TLitchfield Flying Club Inc · Litchfield, MNBuilt 1978 · S/N 38-78A0181 N9742BHarp Aviation LLC · Flemington, NJBuilt 1981 · S/N 172RG1005 N9742MCastro Laura · Phoenix, AZBuilt 1967 · S/N 670036 N9743BVinson Paul E DBA · Gainesville, GABuilt 1981 · S/N 172RG1006 N9743HReese Jeffrey D · Portland, ORBuilt 1981 · S/N 18267990 N9743MAdney William J · Woodville, TXS/N 670037 N9744M44 Mike LLC · Highlands Ranch, COS/N 670038 N97459Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 17276190 N9745MJones Joseph D · Bixby, OKBuilt 1967 · S/N 670039 N97465Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276194 N9746BRegistration Pending · Middletown, DERegistration pendingBuilt 1981 · S/N 172RG1009 N9746YAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1981 · S/N 21064585 N9747GPavlu Aerial Spraying LLC · Ness City, KSS/N 18801587T N97489Neron II LLC · Lewes, DES/N 17276197 N9749G3 B Farms Inc · Pinetown, NCFirst renewal noticeBuilt 1974 · S/N 18801588 N974CAFranks Gary W · Bolivar, MOS/N 17264459 N974RCRafael Cisneros LLC · Wilmington, DEBuilt 1981 · S/N 21064459 N9750LLouisiana Department Of Public Safety · Baton Rouge, LABuilt 1986 · S/N 17276608 N9750QPurdy Adrian · Missouri City, TXBuilt 1975 · S/N 17265789 N9751MSchott Milbert F · Richland Center, WIBuilt 1967 · S/N 670045 N97528Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276308 N9752BUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1981 · S/N 172RG1012 N97549Brandt Jeremy · Torrance, CAS/N 17276206 N9754MZiaja Rebecca · Virginia Beach, VABuilt 1967 · S/N 670048 N9755DSkyline Solutions Inc · Deland, FLBuilt 1984 · S/N 17276227 N9757TDevevo Warren C Sr · Sylvania, GABuilt 1978 · S/N 38-78A0189 N9758BSherwood Aviation LLC · Lewes, DES/N 172RG1015 N9759GMcneill Dudley · Happy, TXBuilt 1974 · S/N 18801592 N9759HHavelka Glen C · Boerne, TXBuilt 1981 · S/N 18268001 N975BCThompsen David · Clifton, ILBuilt 2017 · S/N 584-2017 N975BSSaurdiff Benjerman D · Two Rivers, AKBuilt 1979 · S/N 302-79 N975BWWeidendorf Investments LLC · Hinckley, MNS/N 17270718 N975RJDavison Michael J · Big Rapids, MIBuilt 1982 · S/N 24-1268 N975SGage Christopher R · Truckee, CABuilt 1999 · S/N 1263-99 N9760MNeal Alan B · Cherry Valley, CABuilt 1967 · S/N 670054 N9763HReed Grain & Bean Inc · Buhl, IDBuilt 1981 · S/N 18268004 N9763MWaldren Paden · Garden Valley, CABuilt 1967 · S/N 670057 N9763TBiotech Vending LLC · Escondido, CABuilt 1978 · S/N 38-78A0192 N97642Bravo Zulu Aviation Inc · Chattanooga, TNBuilt 1982 · S/N 24-1343 N9764MSilcott Robert W III · Fairview, OKBuilt 1967 · S/N 670058 N97650Updraft LLC · Kissimmee, FLS/N 17276218 N9765HAspen Helicopters Inc · Oxnard, CAS/N 18268006 N9765MMahoney James P · Renton, WABuilt 1967 · S/N 670059 N97662Northwest Alabama Holdings LLC · Spruce Pine, ALBuilt 1984 · S/N 17276219 N97674Oc Flight Lessons LLC · Costa Mesa, CABuilt 1984 · S/N 17276220 N9767MMcgill James D · Tucson, AZBuilt 1967 · S/N 670061 N97681Buiqui Aerospace Corp · Kissimmee, FLBuilt 1984 · S/N 17276221

Back to AD 80-25-07 R1