AD 73-26-07 R3
Registered aircraft · 567
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:73-26-07-R3')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-26-07-R3')
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:73-26-07-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-26-07-R3') 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.
N2441KCarpe Caelum LLC · Joplin, MON245CFEagle Creek Aviation Services Inc · Indianapolis, INN248JHExecutive 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, NDN260MCBig Horn Airways Inc · Sheridan, WYN261WBNorthern Jet Sales LLC · Port Saint Lucie, FLN2650MSierra 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, CAN2749GLo Pilato Family Flights Inc · Coral Gables, FLN274GCPro Aviation II LLC · Ogden, UTN2750GLo Pilato Family Flights Inc · Wilmington, DEN276CACbg LLC · Wilsonville, ORN280KLCbg LLC · Wilsonville, ORN2820GColin Irons Diving And Pools Service · Denton, TXN28LHKavalair LLC Series B · Marion, MTN290KAN290ka LLC · Clare, MIN29GDAriel Seafoods Aviation LLC · Destin, FLN29PRGa Flying LLC · Kalispell, MTN2NQSurdex Corp · Chesterfield, MON2RAFlying Mu2 LLC · Reno, NVN3004KAg Solutions LLC · Satanta, KSN3004VCarroll Flying Service Inc · Lake Providence, LAN3024ULarson Ag Inc · Stephen, MNN3061NGreat Plains Spraying Inc · Colby, KSN307PATgf Aviation LLC · Lafayette, LAN3083ZSilverwings Ag LLC · Burlington, CON30854Cornerstone Financial Enterprises LLC · Mesquite, NVN309HGConstruction Helicopters LLC · Howell, MIN3108BGas Wilson Inc · Traverse City, MIN3114GM E S LLC · Anchorage, AKN31171Cbg LLC · Wilsonville, ORN312MBN312mb LLC · Wilmington, DEN313JMFlatiron Air LLC · Hotchkiss, CON316TTThompson Aviation LLC · Dennis, TXN317BCAsc Aviation LLC · Kalispell, MTN318AKN318ak LLC · Anchorage, AKN31JVMarc Inc · Bolton, MSN320GBAloft Aviation Services LLC · Spartanburg, SC
Back to AD 73-26-07 R3