AD 75-12-07
Registered aircraft · 338
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-12-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-12-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-12-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-12-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.
N333ESRebus LLC · Andover, KSN3364LLopez Edwin · Germantown, TNN33VTTjr Aviation LLC · Orefield, PAN350CHFly Bye LLC · Georgetown, DEN350SDAmerican Aircraft Sales LLC · Lincolnshire, ILN367ATL&R Aircrafts Corp · Boynton Beach, FLN36CGDay Edwin Daniel · Richland, WAN36DLCroll Robert H III · Jacksonville, ORN36EWSalzer Dustin J · Weatherford, TXN372NMShelter Michael R · Sandy Lake, PAN374TAVintage Aero Inc · Brandon, FLN3835CPreferred Airparts LLC · Apple Creek, OHN3TQAbove Blue Line LLC · Austin, TXN3VJMiasnikowicz Victor · Lancaster, PAN400WMBryan Craig · Ellisville, MSN40484Sunland Air Inc · Frederick, MDN4063QThin Air Inc · Hays, KSN414SGCloud Niner Aviation LLC · Zephyrhills, FLN417EC417ec LLC · Sheridan, WYN41LCBowen William A III · California, MDN42SSBas Part Sales LLC · Greeley, CON431BRLockyer Roch Jr · Austin, TXN433YHRegistration Pending · Stuart, FLRegistration pendingN4420MJohnson Capital LLC · Colleyville, TXN444STPeterson Ocean Tours LLC · Pace, FLN4546QHarlow Jack M · Benbrook, TXN466QBiziorek Thomas R · Harbor Springs, MIN46CGGlobal Building Investments Inc · Scottsdale, AZN46RKAir Positive LLC · Selbyville, DEN47BGVonweisenstein Thomas W · Brentwood, TNN497JMBazzi Aviation LLC · Newark, DEN4PJAnderson Richmond E Jr · Orlando, FLN500RFJones Anthony Blake · Sylacauga, ALN533CEHoward David D · Winner, SDN53PTRegistration Pending · Anacortes, WARegistration pendingN558BTKeesling Roger L · Starkville, MSN567Herr John Robert · Saint Petersburg, FLFirst renewal noticeN5701MConsulat Inc · Cheyenne, WYN5709MClear Blue Western Sky LLC · Anthem, AZN5711MSwager Joel P · Ione, CAN5712MDay Star Aviation Inc · Locust Grove, GAN5715MExpress Air LLC · Wilmington, DEN5720MSongbird Aviation Inc · Lawrenceville, GAN5721MWood Michael D · Huntington Beach, CAN5731MZortman Micky P · Mexico, MON5741MCoolidge Robert · Rio Vista, TXN5746MFlyaware Inc · Lewes, DENon-citizen corporation, flight hours not reportedN575HBHot Damn Flying Service LLC · Palm Coast, FLN5762MNewby Aviation LLC · Pingree Grove, ILN5768MHeal Your Heart LLC · Redding, CA
Back to AD 75-12-07