AD 2016-07-24
Registered aircraft · 4,096
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:2016-07-24')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-24')
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:2016-07-24') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-24') 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.
N1797HRons Air Service Inc · Two Buttes, COFirst renewal noticeN17AMFarmdog Aviation LLC · Lafayette, INN17GWSalus Aviation LLC · Jupiter, FLN17HLRiley Charles S · Littleton, CON17MHEcho Aviation LLC · Verona, WIN17NWEye Clinic Building Lllp · Bismarck, NDN17UAce Flight LLC · Houma, LAN1811HLeggett Jason · Bogue Chitto, MSN1816HKiever Robert P · Summerland Key, FLN1821EHth Companies Inc · Union, MON1827HWard Austin · Kokomo, INN1831HKulp Clayton H · Wichita, KSN1837HYeagley Daun III · Moraine, OHN1842SFry William A · Willmar, MNN184PSStrama Aviation LLC · Ocala, FLN184XTitan Island Aviation LLC · Houston, TXN1852EMarshall Dennis Ray Jr · Pottsboro, TXN1852HI Fly Stl LLC · Saint Louis, MON1856EGv Air Inc · Medford, ORN1856HVieman John D · Owensville, MON1862TBradley Max T II · West Plains, MON1865SPima County Board Of Supervisors · Tucson, AZN186THSandy Hook Aviation LLC · Sandy Hook, MSN1873HBlue Canoe Aviation LLC · Chicago, ILN1879ERaw Racing Inc · Puyallup, WAN1879HRegan Robert C · Kent, WAN187WWOsprey Aviation LLC · Riva, MDN1886HGoodwin Joseph N · Grass Valley, CAN188GWBrown Die Casting & Manufacturing Inc · Royse City, TXN188SRRogers Steven Trustee · Ogden, UTN1894EDelvest LLC · Grosse Pointe, MIN189MKS2ar Aviations LLC · Lantana, FLN189MWWilliamson Aviation Inc · Tullahoma, TNN18BKShandog Air LLC · Ashland, KYN18DLBelov Mikhail · Greenwood Village, CON18EGBoanco Inc · Lafayette, INN18MRMorey Airplane Co Inc · Middleton, WIN18SGBennett Jeannette DBA · Joiner, ARFirst renewal noticeN18TN18t Ltd · Wilmington, DEN18TCAviotti Inc · Henderson, NVN18VUVincennes University · Vincennes, INN1905B605 Aviation LLC · Aberdeen, SDN1905ERusso Louis A Jr · Houston, TXN1908GAir Z Flying Service Inc · Richmond Heights, OHN1915WPasha Mohammad A · Muscatine, IAN1918EGuano Air LLC · Palmetto Bay, FLN1918JCoastal Satellite Inc · Woodland Hills, CAN1919JValiair Lc Trustee · Casper, WYN1919LSmith Sydney O · Lithonia, GAN191CTBessemer Plywood Corp · Bessemer, MI
Back to AD 2016-07-24