Skip to content

Registered aircraft · 81,720

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N161SG3bs Aviation LLC · Wilmington, DEBuilt 2005 · S/N 1000-2005 N161SMMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 28-7916508 N161SWLober Cameron K · Matthews, NCBuilt 1966 · S/N 28-3752 N161TFAirmart Inc · Lexington, KYBuilt 2022 · S/N 2881549 N161WMWagner Scott · Cranberry Township, PABuilt 1988 · S/N 1 N162Payne David J · Eagle River, AKBuilt 1957 · S/N 22-5677 N1620ABeaver David W Trustee · Wasilla, AKBuilt 1952 · S/N 18-1263 N1620GDrexler Charles T · Albuquerque, NMBuilt 1968 · S/N 123 N1620PNielsen Mona · Ford, WABuilt 1954 · S/N 22-2434 N1621Diem Ronald · Myerstown, PABuilt 2025 · S/N 18283315 N1621HDavis Vance · Del Valle, TXS/N 177RG0794 N1622AKelly Steven L · Saline, MIBuilt 2016 · S/N 5574 N1622HSweeney Kay M · Kirkland, WABuilt 1975 · S/N 177RG0795 N1622PBaker Kenneth C · Brenham, TXBuilt 1992 · S/N 3213040 N16237Main Line Assets LLC · Wayne, PABuilt 2005 · S/N 172S9912 N1624Going Somewhere LLC · Dover, DEBuilt 2018 · S/N 18283056 N16244Oakland William S · New Port Richey, FLBuilt 1973 · S/N 28-7305211 N1624GBarnett William M · Wasilla, AKBuilt 1968 · S/N 623 N162505b Aviation LLC · Duncan, OKBuilt 1973 · S/N 28-7305212 N16252Robbins Warren N · Chandler, AZBuilt 1973 · S/N 28-7305213 N16257Chauvet Nicolas · North Kingstown, RIBuilt 1973 · S/N 28-7305216 N1625GPippert Jim · Dysart, IABuilt 1968 · S/N 127 N1625JCain Philip K · Escondido, CABuilt 1968 · S/N 28-24818 N1625LArtime Jorge Daniel · Miami Beach, FLBuilt 1979 · S/N 13 N1625PGauthier Robert Jones · Melba, IDBuilt 1954 · S/N 22-2439 N1625RQuebe Jeffrey R · Fort Worth, TXFirst renewal noticeBuilt 1976 · S/N AA1B-0625 N1626JLawrence Gavin · Borger, TXBuilt 1967 · S/N 28-24013 N1626RRedman Lee · Moore, OKBuilt 1976 · S/N AA1B-0626 N1627Johns Trevor M · Seattle, WABuilt 2015 · S/N 0021 N16273Taildraggers LLC · Syracuse, KSBuilt 1973 · S/N 28-7305217 N16278Cademartori Joel T · Norris, TNBuilt 1973 · S/N 28R-7335121 N16279Deyoung Christopher H · Tucson, AZBuilt 1973 · S/N 28-7310083 N1627APlettner David C · Sutton, NEBuilt 1951 · S/N 18-1267 N1627EWichterman George J Trustee · Fort Myers, FLBuilt 1978 · S/N 17271070 N1627HCirrus Services Inc · Fargo, NDBuilt 1977 · S/N 28-7716028 N1627PMiller Wesley M · Crookston, MNBuilt 1954 · S/N 22-2441 N1627RRoettger Thomas D · Finksburg, MDBuilt 1976 · S/N AA1B-0627 N16283Winn Philip P · Salem, OHBuilt 1973 · S/N 28-7325231 N16284Rocco Jeffrey M · Carson, CABuilt 1969 · S/N 28-26015 N16288Bailey Brent M · Dalzell, SCBuilt 1973 · S/N 28-7325234 N16289Williams Kevin L · Buchanan, TNBuilt 1973 · S/N 28-7325235 N1628GBistline Quentin J · Pahrump, NVS/N 626 N1628HWarrior N1628h LLC · Huntsville, ALBuilt 1977 · S/N 28-7716029 N16292Morcom Aviation Services Inc DBA · Everett, WABuilt 1973 · S/N 34-7350125 N16293Quale Jeffrey L · Craig, COFirst renewal noticeBuilt 1973 · S/N 28R-7335123 N16299Piper Niner Niner LLC · Evansville, INBuilt 1973 · S/N 28-7310084 N1629EAnson Air LLC · Sugar Land, TXBuilt 1978 · S/N 17271072 N1629JBuckley Barney P · Colfax, WABuilt 1967 · S/N 28-24016 N1629RMavi Aviation Services LLC · Hickory, NCS/N AA1B0629 N162ACWatson Tommy R · Thibodaux, LABuilt 1997 · S/N 1235-97

Back to AD 81-18-04 R2