Registered aircraft · 81,728

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.

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 N290MMBatchelor Mark S · Auburn, CABuilt 2001 · S/N 001 N290NDChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 4496021 N290PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12864 N290RLRichardson Scott · Sunnyvale, CABuilt 2020 · S/N 235-181-173 N290RMCxairco LLC · Yuma, AZBuilt 2010 · S/N 18282215 N290SHParker Helicopter LLC · Watsonville, CABuilt 2007 · S/N 4186 N290TWChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S9020 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 N29157Midwest Aero Inc · Bay City, MIBuilt 1979 · S/N 32-7940130 N29159Southridge Developments Inc · San Miguel, CAFirst renewal noticeBuilt 1974 · S/N 17264103 N2915GWalls Properties LLC · Paragould, ARBuilt 1979 · S/N 28-7911243 N2915LZorro Stephen · Rocklin, CABuilt 1967 · S/N 670309 N2915VRegistration Pending · Bellevue, WARegistration pendingS/N 131 N29160Felber Dave A · Florissant, MOBuilt 1974 · S/N 17264104

Back to AD 81-18-04 R2