AD 49-50-01
Registered aircraft · 9,191
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:49-50-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:49-50-01')
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:49-50-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:49-50-01') 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.
N10534Shergi Nikolai W · Franklin, INN1054FGilson Gareth F · Phoenix, AZN1055HReddell Justin · Jasper, ARN1057NMiller Richard L · Erie, CON1059EDeaero LLC · Darwin, MNN1060HJohnston Jeffery A · Eagle River, AKN1064KStein Andrew · Modesto, CAN1067HAmerell Kathryn · Wasilla, AKN106FBZimmerman Frederick J · Boulder City, NVN1070HGeary Charles L · Wasilla, AKN1071HBeck Douglas J · Bloomington, MNN1072HBeckman Thomas J · Pocahontas, ARN1075HBartholomew Dana C · Madison, WIN1077HHadley Everett F · Dayville, CTN10785Burton Robert E Jr · Vancouver, WAN1078KClairday Preston H · Melbourne, ARN1083HHead Wesley J · Homer, AKN10866Mcglothlen Mike C · Muscatine, IAN1088ESmith Mark E · Lakeville, NYN1088HAerotechniques LLC · South Kent, CTN108RHBashaw Nathan R · Salem, NYN1091HHuber Gregory A · Medina, OHFirst renewal noticeN10967Weeks Kermit A · Polk City, FLN1096EMarrs David R DBA · Bella Vista, ARN1096HRegistration Pending · Wasilla, AKRegistration pendingN1097HPoulter Thomas R · Chelsea, MIN10982Burris Kye A · Gillett, ARN10996Coughlin Edward L · Cazenovia, NYN1099HTzenis Michael · Lakeville, MNN109SCCobb Lee C · Van Alstyne, TXN10ANSouth Dakota Hist Avn Preservation & Educ Soc Inc · Canistota, SDN10KSMorris Jerry M · Summerville, SCN10MJHocker James L · Brookville, OHN10XSWittman Flying Service · Ripon, WIN11018Jepsen Dorian B · Selah, WAN1103Schmidt Thomas P · Nunica, MIN1103DOber John A · Candor, NYN1104DRymill Mark R · Belmont, CAN1105DGilman Larry E · Reno, NVN1105HMaya Aviation LLC · Lee, NHN1106DMurdock Mark F · Ketchikan, AKN1106TPierce John R · Hulett, WYN1109BWeymouth James H · Jackson, MIN1109DMcqueen Alan G · Cocoa, FLFirst renewal noticeN1109WOrton Aviation LLC · Walker, MNN110QSilvaire Air LLC · Gun Barrel City, TXN110RHHardin Donald D Trustee · Kirkwood, MON110RRGalloway Landings LLC · Caledonia, MIN110SLaysoncraft LLC · Clarkston, MIN110XPlayter Bud W DBA · Gowen, MIFirst renewal notice
Back to AD 49-50-01