AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N5195YUrbana Aircraft LLC · Urbana, MDN51960Xin Han Aviation LLC · Atwater, CAN5196AParker Todd S · Kaysville, UTN5196DPugsley Todd F · Albany, ORN5196GOlasz Jonathan S · West Barnstable, MAN5196PEsbenshade Wilmer R · New Holland, PAN5197ETspy Services Inc · Wilmington, DEN5197HSullivan Edward A · Remsenburg, NYN5197JEide Paul · Moses Lake, WAFirst renewal noticeN5197KN5197k LLC · Cheyenne, WYN5197RMedia Stew LLC · Carson City, NVN5197TUw Flying Club Inc · Sun Prairie, WIN5198DHaw LLC · Wilmington, DEN5198EGaruda Flight Training LLC · Miami, FLN5198HBranson William E · Stokesdale, NCFirst renewal noticeN5198JMichigan Dept Of Natural Resources · Roscommon, MIN5198QValiair Lc Trustee · Casper, WYN5198TBlack Dog Aviation LLC · Troy, MIN5198UFerguson Kenneth R · Tehachapi, CAN5198VMaddock Jay B · Sugar Grove, ILN51991Raider Aviation LLC · Lubbock, TXN51996Skywarrior Flight Training Inc · Pensacola, FLN5199BFly172s LLC · Peoria, AZN5199ESnowden Andrea K · Anchorage, AKN5199JG&M Aircraft Inc · Wheat Ridge, CON519AMRegistration Pending · Manheim, PARegistration pendingN519ERStick & Rudder Club Inc · Waukegan, ILN519MPUpdike Jesse J · Kenai, AKN519MQMgnh Services LLC · Houlton, MEN519NDChristiansen Aviation LLC · Wilmington, DEN51AKSchroth Charles D DBA · Gustavus, AKN51BWMcclymond Bruce W · Breckenridge, TXN51CHEcho Acquisitions LLC · Dover, DEN51CMCorley W Michael · Mc Minnville, TNN51CVMarotta Daniel C · Tijeras, NMN51ESBurton Donald O · Mooresville, NCN51FACoffey Michael A · White Lake, MIN51HFSan Mateo County Sheriff'S Office · Redwood City, CAN51MSDekervor Marc Phillippe II · La Mesa, CAN51PHAasen Christopher N · Corvallis, ORN51RMiozzi Thomas E · Jamestown, RIN51SARedtail Partners LLC · Moab, UTN51SPDepartment Of Public Safety · Dover, DEN51UDAlf Ix LLC · Chicago, ILN51WMMacair Aviation LLC · Xenia, OHN51WT51 Whiskey Tango LLC · Henrico, VAN51YTRupp Steven S · Cameron Park, CAN520Registered aircraftN52004Jones Steve M · Anchorage, AKN52009Sale Reported · Palmer, AKSale reported
Back to AD 79-10-14 R1