AD 75-01-07
Registered aircraft · 2,118
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:75-01-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-01-07')
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:75-01-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-01-07') 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.
N4127SKrall Jeff P · Mitchell, SDN412YMurrieta Humberto · San Antonio, TXN4135SRazzyfish Inc · Colton, CAN413GKKgc Holdings Ltd · Newark, TXN413KJHuber Jeffrey C · Sidney, OHN4143SFrederickson Mark T · Cameron Park, CAN4149SDelgado Dimitri Antonio · Tampa, FLN4151SMidland Avionics LLC · Louisville, KYN4154SWilanco Inc · Berkeley, CAN4163ASalida Aviation Partnership Group · Moffat, CON4164SFabien Turpaud Corp · Lewes, DEN416GFHahn Steven P · Hutchinson, MNN4175SBauman Loren A · Lewisville, NCN4177SMiles Insurance Inc · Inverness, ILN4180SPalomino Princess Express LLC · Helena, MTN4187SJ&S Aviation Services LLC · Hastings, NEN4192ARocky Mountain Aviation Inc · Wilmington, DEN4192SStecklein Aviation LLC · Colleyville, TXN4197SIndependence Aviation Inc · Scottsdale, AZN41CMClark Patrick L · Kenai, AKN41SBBrillaud Stephen A DBA · Germantown, TNN4212SColburn Reno Bryan · Turner, MTN4217SAnla Aviation LLC · Bentonville, ARN422GRHolden Virgil Gary Trustee · Upland, CAN423MDSublett Charles M · Tulsa, OKN423WTCoons John K · Winston Salem, NCN4245AMac Flight LLC · Conway, ARN425MGGrinnan Michael · Stafford, VAN4272SSchechter Stuart · Great Neck, NYN4275SEvergreen Aviation LLC · Franktown, CON427PWLangford Stephen C · York, SCN42800Asbury William J · Fresno, CAN4280SYoung Daniel R · Germantown, TNN428KRLilly James D · Columbia, MDN428TLJoe Rushing Plumbing Co Inc · Lubbock, TXN42ABGallaway Michael T · Dallas, TXN42LBRigney Timothy D · Troy, VAN42WKMariash Cary Norman · Indianapolis, INN4301WNash Matthew · Edmonds, WAN4302WDagenhart Ronald Jason · Westerville, OHN4310SVelk Vincent F · Havre, MTN4312WBreitbarth Brian · Canby, ORN4317WMurray Patrick G · Moraga, CAN4321EHarper Henry Jr · Mesquite, NVN4321SBeech Peak Aviation LLC · Boulder, CON4322WSnell Steve · Scotts Valley, CAN433DReyenga Steven G · Shreveport, LAN433SBesedin Thomas E · Islandia, NYN4340WHanger Aviation Inc · Charleston, SCN4342AR&B Air LLC · Clayton, MO
Back to AD 75-01-07