Registered aircraft · 68,369

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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.

N1424XLewis Keith W · Clearwater, FLBuilt 1975 · S/N 28-7515318 N14255J T Howell And Son LLC · Jackson, LABuilt 1974 · S/N 18-7409058 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 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 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 N1428VBreitenbucher Paul W · Lodi, CABuilt 1975 · S/N 17264687 N1429Rapalyea Eugene L · Santa Rosa, CABuilt 1969 · S/N 1 N14298Campbell Kenneth D · Soldotna, AKBuilt 1974 · S/N 18-7409062 N14299Compton John D · Morgan, UTBuilt 1974 · S/N 18-7409064 N1429CLarge Jonathan B · Mahnomen, MNBuilt 1953 · S/N 22-1183 N1429DChan Michael · Green Cove Springs, FLS/N 1429 N1429ESullins David A · Santa Barbara, CABuilt 1978 · S/N 17270996 N1429XRegistered aircraftBuilt 1975 · S/N 28R-7535278 N142ACFly For Fun LLC · Rockville, MDBuilt 1992 · S/N 683-92 N142ASGray William Colin · Seattle, WABuilt 1966 · S/N 28-22530 N142BLipinski Glen E · Chandler, AZBuilt 1992 · S/N 10134 N142BESugar Pop Group LLC · Saco, MEBuilt 2001 · S/N 14103C N142CJSheppard Travis R · Redmond, ORBuilt 2007 · S/N 91286 N142DGYuba Sutter Aviation · Olivehurst, CABuilt 1981 · S/N BB-01 N142DMRegistered aircraftBuilt 1997 · S/N 584 N142DWNelson Jim · Midlothian, TXBuilt 1998 · S/N 2449 N142EN142e LLC · Page, AZBuilt 1967 · S/N 30-1479 N142EJAskwig Michael C · Lincoln, MIS/N 372 N142FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290177 N142GVan Strien Greg · Lowell, MIBuilt 2019 · S/N 22278 N142HAHonaker Group LLC · Sellersburg, INBuilt 1975 · S/N 17266306 N142JPEvans Jesse G · Powder Springs, GABuilt 2000 · S/N 23636 N142KSSoares Ken J · Pasco, WABuilt 2007 · S/N 90514 N142KYSchachle Robert Godfrey · Wasilla, AKBuilt 1960 · S/N 518 N142LBFleischer Gregory P · Flower Mound, TXFirst renewal noticeBuilt 1942 · S/N 42-98694GF N142LESky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 01 N142LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 4496177 N142MGSanta Maria Software · Santa Maria, CABuilt 1999 · S/N 1 N142MJFranklin Justin L · Mimbres, NMBuilt 1984 · S/N 352 N142NDSkyblue Aviation Cr Inc · Merritt Island, FLBuilt 1989 · S/N 2841229 N142PLZbigniew Chudy · Southington, CTBuilt 2018 · S/N 70277 N142SMShandelee Energy LLC · Tulsa, OKFirst renewal noticeBuilt 1994 · S/N SMS01 N142TReed Britt A · White Salmon, WABuilt 1953 · S/N 18-2256

Back to AD 90-04-06 R1