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.

N1420JMaupertuis Frederick E · Henderson, NVBuilt 1975 · S/N 420 N1420POrchid Aviation LLC · Palm Springs, CABuilt 2007 · S/N 18281888 N1420RShires James D · Merrillan, WIS/N AA1B-0520 N1420UWall Corey · Garner, NCBuilt 1976 · S/N 17267088 N1421AKoplitz Wesley D · Oshkosh, WIS/N 22-336 N1421BTepper John E · Shady Cove, ORBuilt 1954 · S/N 183906 N1421JBrindle Richard L · Pleasant Hall, PABuilt 1975 · S/N 421 N1421PSkyline Enterprises Inc · Anchorage, AKRegistration revokedBuilt 1956 · S/N 23-476 N1421RGreenawald Richard J · San Mateo, CABuilt 1975 · S/N AA1B-0521 N1421TBurr Charles R Jr · Palm Bay, FLBuilt 1972 · S/N 34-7250314 N1421WSurgent Richard L · Wall Township, NJBuilt 2002 · S/N 95-0308 N1422Waller Jerry Wayne · Diamondhead, MSBuilt 1989 · S/N WAL-1 N14226Lathem Douglas · Dalhart, TXBuilt 1974 · S/N 18-7409099 N1422CChristiansen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 172S12894 N1422EA S Air LLC · Lantana, FLBuilt 1978 · S/N 17270991 N1422JCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13175 N1422XDt'S Aviation LLC · Garden City, KSBuilt 1975 · S/N 28-7525287 N1423JSandyland LLC · Madison, FLBuilt 1975 · S/N 423 N1423TWaggoner Kevin M · Donnellson, IABuilt 1972 · S/N 28-7225509 N1423UPatkotak Crawford Ahkivgak · Barrow, AKBuilt 1976 · S/N 17267090 N1423XFigueroa Rafael A Jr · Coulterville, CABuilt 1975 · S/N 28-7515317 N1423ZVan Buskirk Bill J · Wasilla, AKBuilt 1952 · S/N 18-1924 N1424AStacey Steve L · Hutchinson, KSBuilt 1951 · S/N 22-338 N1424CGlendoe Inc Trustee · Wilmington, DEBuilt 2005 · S/N 18281610 N1424EFamily Rec Corp · Marysville, KSBuilt 1978 · S/N 17270993 N1424JDuwelius Sue DBA · Hermiston, ORBuilt 1975 · S/N 424 N1424MFly High LLC · Mobile, ALBuilt 1973 · S/N 32-7300043 N1424TFoster Adam J · Houston, TXBuilt 1972 · S/N 28-7225511 N1424UCavern City Flight School LLC · Carlsbad, NMBuilt 1976 · S/N 17267091 N1424VRtd Aviation LLC · Hillsborough, NJBuilt 1974 · S/N 17263569 N1424XLewis Keith W · Clearwater, FLBuilt 1975 · S/N 28-7515318 N14255J T Howell And Son LLC · Jackson, LABuilt 1974 · S/N 18-7409058 N1425KTopaircraft Classic Wings Holding LLC · Eureka, MOS/N 10153 N1425NJolley William H · Wamsutter, WYS/N 22950 N1425RCambridge Aircraft LLC · Hot Springs, ARS/N AA1B-0525 N1425TSkydance Aviation LLC · Norfolk, VABuilt 1972 · S/N 28R-7235286 N1425XHowell Joshua · El Cajon, CABuilt 1975 · S/N 28-7515319 N14269Andersen Roger · Curtis, NEBuilt 1974 · S/N 18-7409059 N1426JKvistad Charles O · Granite Falls, MNBuilt 1975 · S/N 426 N1426THillcrest Of Central Fl LLC · Auburndale, FLBuilt 1972 · S/N 32-7200038 N1426ULegried Brian K · Longville, MNBuilt 1976 · S/N 17267093 N1426XBair Preston W Jr · Coshocton, OHBuilt 1975 · S/N 28-7515321 N14275King Kevin L · Anaheim, CABuilt 2014 · S/N 31 N1427CGdm Properties LLC · Huron, OHBuilt 1953 · S/N 22-1179 N1427XAlis Aquilae LLC · Opelika, ALBuilt 1975 · S/N 28-7515402 N14281Technical Education Services Inc T/A · Virginia Beach, VABuilt 1972 · S/N 27-4843 N1428CHolder Ward S · Oxnard, CARegistration revokedBuilt 1953 · S/N 22-1180 N1428JLeedham James E DBA · Mazeppa, MNBuilt 1966 · S/N 28-3539 N1428RShiner Tod W · Talking Rock, GABuilt 1975 · S/N AA1B-0528 N1428UKops Kenneth M · East Helena, MTBuilt 1976 · S/N 17267095

Back to AD 81-18-04 R2