AD 81-18-04 R2
Registered aircraft · 81,733
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
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.
N84TXBrooks Nathan · Manhattan, KSN84VCExperimental Flight Test Solutions LLC · Seattle, WAN84VHWeber David A · Snohomish, WAN84WDFortman James · Vancouver, WAN84WMErickson Lee A Trustee · Fargo, NDN84WPJayanthi Venkata R · Columbus, OHN84WYHacds LLC · Missoula, MTN84ZRomeo Aviation Ltd · East Sparta, OHN85007Sidell Joel R · Brighton, CON8500DScootair LLC · Alburgh, VTN8500QEilinger Richard L · Hertford, NCN8500UGlobal First Capital Aviation Group LLC · Amarillo, TXN8500ZKreilich Jonathan E · Rogerson, IDN8501DStrausser Brian J · Lower Burrell, PAN8501LSnider Scott E DBA · Turner, MTN8501QLilly James E · Alamosa, CON8502DConrad Dylan · Randolph, WIN8502EJones Derick · Moultonborough, NHN8502FOrtiz John Pasqual III · Loma Linda, CAN8502VAngel Aviation Inc · Peoria, AZN8502WWinker Kurt F · Los Lunas, NMN8503Finney Michael E Trustee · Albany, INN8503CScites Robert W · Toney, ALN8503EB&B Aviation Holdings LLC · Pembroke Pines, FLN8503JClark T J · Saint George, UTN8503NKirkland Joseph Talmadge III · Memphis, TNN8503YRoberti John O · Barre, VTN8504LTexas Soaring Association · Midlothian, TXN8505Lunetta Peter Joseph Jr · Niskayuna, NYN8505DRegistration Pending · Wilmington, DERegistration pendingN8505GBailey John · Effingham, ILN8505NMahffey Gary L · Parachute, CON8505WMcnamara Kevin Jr · East Aurora, NYN8505YCli Aerospace LLC · Appleton, WIN8506NTiller Aviation LLC · Omaha, NEN8506WWestenburg Garrett V · Porter, TXN8506YWilliams Russell D · Rehoboth Beach, DEN8507DFischer Duane A · New Baden, ILN8507ERifenburg Brian K · Ward Cove, AKN8507YWhiteley Robert L · Pittsburg, CAN8508CHobart Aviation Inc · Akron, OHN8508DHuhndorf Joshua L · Port Ludlow, WAN8509DVeal Petra I · Sterling, AKN8509WMoreno Rodrigo S · Phoenix, AZN850ATAtp Taa LLC · Wilmington, DEN850DFFlying J Services LLC · Jourdanton, TXN850FGMustang Sally Aviation LLC · Camden, SCN850FSParagon Airplane Leasing Co · Fort Myers, FLN850RSSeckerson Roy M · Jamestown, NDN850SPAviolease LLC · Vancouver, WA
Back to AD 81-18-04 R2