AD 2016-18-17
Registered aircraft · 699
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-18-17')
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-18-17')
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-18-17') 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-18-17') 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.
N2237DFountain Flying Service LLC · Moscow, IDN2239CJk Skyfarm LLC · Adairville, KYN2245SFernandez Rosario Yailin · Imperial, CAN2250PPeterson Kenneth J DBA · Staples, MNN2254SRustys Flying Service · D Hanis, TXN2256ATwin Cities Aviation Inc · Yuba City, CAN225MMJ & M Aircraft Holding LLC · Bellaire, TXN225TDCat Air LLC · Melba, IDN226KLCbg LLC · Wilsonville, ORN226MKN226mk Corp Trustee · Wilmington, DEN226XXInternational Air Services Inc Trustee · Carson City, NVN2270CBenrud Aviation LLC · Rice, MNN2270SEarls Spray Service Inc · Breckenridge, MIN2271ZPlane LLC (The) · Grove, OKN227JTWoody Whitefish LLC · Salem, ORN227LCBemidji Aviation Services Inc · Bemidji, MNN227LJMetro-Jet LLC · Downey, CAN228SDGeneral Atomics Aeronautical Systems Inc · San Diego, CAN22CG316 Extreme LLC · Basalt, CON22MZChurchill Robert Jr · Wasilla, AKN2300ZProvost Michael A · Jefferson, GAN233PJLwkimber Interests Management LLC · Houston, TXN233RCRico Marketing Corporation · Flint, MIN23NWCsc Delaware Trust Co Trustee · Wilmington, DEN241DHUas Transervices Inc · Boca Raton, FLN2441KCarpe Caelum LLC · Joplin, MON245CFEagle Creek Aviation Services Inc · Indianapolis, INFirst renewal noticeN248JHExecutive King Air Transportation Inc · Wilmington, DEN249DHUas Transervices Inc · Boca Raton, FLN24GTPia Avcenter LLC · Peoria, ILN24PTN24pt LLC · Winter Park, FLN251ESLumphanan LLC · Adams, NEN252BWMotor Vanguard LLC · Campbellsville, KYN253SBN253sb Shares LLC · Liberal, KSN255BHBig Horn Airways Inc · Sheridan, WYN25CTAerial Crop Care Co · Hebron, NDN2609PNtail LLC · Sheridan, WYN260MCBig Horn Airways Inc · Sheridan, WYN261WBNorthern Jet Sales LLC · Port Saint Lucie, FLN264TSFoxtrot Aviation Services LLC · Canton, OHN2650MSierra Aeronautics LLC · Franklin, KYN266MCBighorn Airways Inc · Sheridan, WYN2691WCbg LLC · Wilsonville, ORN26LHKavalair LLC Series A · Marion, MTN2725NWisconsin Aviation Four Lakes Inc · Madison, WIN2728GCbg LLC · Wilsonville, ORN27442Mission Flight · El Monte, CAN274GCPro Aviation II LLC · Ogden, UTN2750GLo Pilato Family Flights Inc · Wilmington, DEN276CACbg LLC · Wilsonville, OR
Back to AD 2016-18-17