Registered aircraft · 68,375

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.

N2908UBarrett H Gould · Myrtle Beach, SCS/N 1023 N29098Gill Stuart W Jr · Kingsport, TNBuilt 1979 · S/N 28-7990436 N2909DPainter Kelly A · Cantwell, AKBuilt 1955 · S/N 26852 N2909QHelman Tom · Evanston, WYBuilt 1979 · S/N 28-7916533 N290AMWheaton Megan E · Orchard Park, NYS/N 2096 N290DBByers Kathleen R · Rigby, IDS/N 698 N290DMWalker George R · Mableton, GAS/N 156 N290DSNakel Inc · Elkton, SDBuilt 2003 · S/N 40.290 N290FBAstarb John E · Baden, PAS/N 1 N290GTForeman Guy W · Valparaiso, INBuilt 2002 · S/N 2090 N290HADon'T Call Me Shirley LLC · Fort Myers, FLBuilt 1966 · S/N 28-3624 N290JHBoyd Bill R · Kennett, MOBuilt 1992 · S/N 96 N290JSMsn LLC · Marietta, GABuilt 2011 · S/N 716-320-560FB N290KCTsunami Skydivers Inc · Las Vegas, NVBuilt 1990 · S/N 1301 N290KZRowland Glen J · Monrovia, INBuilt 2024 · S/N 1220233 N290MGGeorgia Aviation Authority · Eastman, GABuilt 2014 · S/N 2843761 N290MLLimbacher Richard A · Stone Creek, OHS/N 161 N290MMBatchelor Mark S · Auburn, CABuilt 2001 · S/N 001 N290NDChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 4496021 N290RLRichardson Scott · Sunnyvale, CABuilt 2020 · S/N 235-181-173 N290UOhio University · Albany, OHBuilt 2000 · S/N 172S8551 N290VGAlmy David W · Riverside, CAS/N 23-5 N290WMWare George B · Rayne, LAS/N SA100-001 N29107Wrong Brothers Aviation LLC · Brighton, MIBuilt 1974 · S/N 17264100 N2910LBurger Walter F III · Sugar Land, TXBuilt 1967 · S/N 670304 N2910MEkdahl John Edward · Freehold, NJBuilt 1946 · S/N 12-1436 N2910XTallman Richard E · Lykens, PABuilt 1967 · S/N 17700310 N2911Dewinter Thomas A · Waunakee, WIBuilt 1968 · S/N 86 N2911GOrtega Rolando J · Sanford, FLBuilt 1979 · S/N 28-7916537 N2911XRobbins Donald V · Anchorage, AKBuilt 1967 · S/N 17700311 N2912MHarriman Aviation LLC · Pearland, TXBuilt 1977 · S/N 28-7890279 N2912PJackson Robert S · Gallatin, TNBuilt 1955 · S/N 22-3180 N2912XAmbler Carlos S · Mendota, ILBuilt 1987 · S/N 1025 N2912ZFord Charles D · Clifton, TNBuilt 1959 · S/N 22-6882 N2913Brown Engineering Solutions · Lafayette, INBuilt 2011 · S/N 200 N29131Kelly Alex · Arlington, VTBuilt 1987 · S/N 1027 N2913ATruesdell Shannon · Stephenville, TXBuilt 1988 · S/N 1062 N2913EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17271371 N2913MMccay Brian D · Earlysville, VABuilt 1946 · S/N 12-1444 N2913UAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N 44-8107057 N2914AAvier LLC · Beverly, MABuilt 1979 · S/N 28-7916538 N2914BWhite And Blue Wings LLC · Oakland Park, FLBuilt 1979 · S/N 28-7916539 N2914GSchubert Matthew · Belleair Beach, FLBuilt 1979 · S/N 28-7990551 N2914LPanalucent LLC · Saint Petersburg, FLBuilt 1967 · S/N 670486 N2914MPannone Steven R · Palmer, AKBuilt 1947 · S/N 12-1334 N2914PPerreault Guy · Newbury Park, CABuilt 1955 · S/N 22-3182 N2914QEast High Flying · Othello, WABuilt 1987 · S/N 1028 N2914RLandrith Robert L · Mustang, OKBuilt 1969 · S/N 28R-35327 N2914VKyer Barry P · Honey Grove, TXBuilt 1950 · S/N 130 N2914ZEarle Russell John · Reno, NVBuilt 1959 · S/N 22-6884

Back to AD 90-04-06 R1