AD 2012-02-06
Registered aircraft · 659
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:2012-02-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-02-06')
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:2012-02-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-02-06') 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.
N225TDCat Air LLC · Melba, IDN226KLCbg LLC · Wilsonville, ORN226MKN226mk Corp Trustee · Wilmington, DEN2270CBenrud 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, AKN233RCRico 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, OHN266MCBighorn 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, ORN280KLCbg LLC · Wilsonville, ORN28LHKavalair LLC Series B · Marion, MTN28RQRealstaff Rocket LLC · Keizer, ORN290KAN290ka LLC · Clare, MIN290LBGeneral Atomics Aeronautical Systems Inc · Poway, CAN29GDAriel Seafoods Aviation LLC · Destin, FLN29PRGa Flying LLC · Kalispell, MTN2NAHainline Charles H · Pearland, TXN2NQSurdex Corp · Chesterfield, MON2RAFlying Mu2 LLC · Reno, NVN3004KAg Solutions LLC · Satanta, KS
Back to AD 2012-02-06