AD 84-13-05
Registered aircraft · 952
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:84-13-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-13-05')
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:84-13-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-13-05') 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.
N1005ESemaska Victor J · Kensington, CTN1008CBat Flying LLC · Blue Earth, MNN1009EAven Michael D · Georgetown, INN100MPMeyer Christopher R · Colchester, CTN1013PSentinel Services Group LLC · Brooksville, FLN101BYRegistered aircraftN101DKTremper John D · Newton, NJN101HRZia Aerospace LLC · Albuquerque, NMN101JCCoonbottom Aviation LLC · Wilmington, DEN101JRSouthern Aircraft Consultancy Inc Trustee · Casper, WYN101PZJoseph Philip J · Merrimack, NHN1046ERisk Indemnification Professionals LLC · Boston, MAN104JWGobeli Michael T · East Lyme, CTN104MJLift Drag Aviation LLC · El Cajon, CAN104USHartenstine Michael C · Lancaster, CAN105DRMccain William A · Jackson, MSN106ACUpside Down Vt LLC · Milton, VTN1077EGoebel William R · Rhome, TXN107ACBad Attitude LLC · Lisbon, OHN107AWDust Donald E · London, OHN107GSSharp Roscoe A · Deer Park, WAN107XRQualitair LLC Owner Trustee · MichelstadtN1083EDavis Gregory P · Olathe, KSN108JGStilts Steven · Houma, LAN1091EGlatthaar Richard J · Burbank, WAN109PCFort Wayne Aircraft LLC · Fort Wayne, INN10MUMorgan Daniel R · Salem, INN10WYCarraway Terry Jr · Aberdeen, MDN1106ESlavens Timothy W · Howard City, MIN1110ERegistration Pending · Hanford, CARegistration pendingN1117ELocke Mason · Cloudcroft, NMN1119ECole Jack A · Sun City West, AZN111GPVan Haitsma Kelley · Fort Worth, TXN111LSGrant William S · Azle, TXN111XRRose Carl William Jr · North Fort Myers, FLN11201Moment Stuart L · Urbana, ILN11235Mcdonald Air LLC · Floyds Knobs, INN1124ETuruc Jeffrey Michael · Lake Worth, FLN1138PYs Pharmtech · San Diego, CAN113JJRendleman Robert T · Murphysboro, ILN113PVVaneau Philip M · Kerrville, TXN1144KYoung Bradley M · Vancouver, WAN1144WNimmo Lawrence · Cordova, MDN1145TWilliams Thomas J · Burr Ridge, ILN1146LSak Aviation LLC · Cheney, KSN1159ERegistration Pending · Sherwood, ORRegistration pending, canceledN116DHHoover David · Foster City, CAN1175ENannini Gary S · Lincoln City, ORN1177BTakacs John Paul III · Colorado Springs, CON117TMRegistered aircraft
Back to AD 84-13-05