AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N4756DVertical Investment Strategies LLC · Henderson, NVN4756EAero Missions Inc · Sylacauga, ALN4756JEhling Joseph P · Snohomish, WAN4756LJones Tyler J · Williamsburg, KYN47578Donair Inc · Toledo, OHN47579Gomed Air LLC · Greenville, SCN4757DCalhoun Gerrald E · Leesburg, FLN4757FMulcaire Jess E · Camp Verde, AZN4757KGirard Gregory M · Tucson, AZN4757LMil2atp Inc · Pikeville, NCN4757NTwin Falls Fliers Inc · Twin Falls, IDN4757PRenck Michael R · Red Rock, TXN4757THagen Brian T · Allen, TXN4757UPj Aviation LLC · Eden Prairie, MNN4757YLake Country Lodge · Port Alsworth, AKN47580Sky West Aviation Inc Trustee · Albuquerque, NMN47589Radke John A · Cedar Falls, IAN4758BJaars Inc · Waxhaw, NCN4758DBurt William G · Tullahoma, TNN4758FPhastar Corp · Cleveland, OHN4758JFardell Christopher J · Gilbert, AZN4758KRuvo Scott J · Augusta, NJN4758LStouffer Michael L · De Soto, ILN4758PCole Gary L · Richmond, TXN4758SMcdonald Sales & Leasing Inc · Marshville, NCFirst renewal noticeN4758WBlevins Larry Standley Jr · Oxford, NCN47593Holthaus Donald H · Fort Loramie, OHN47595Tappendorf Dan · Florence, ALN47599N47599 LLC · Senoia, GAN4759BHoover Michael B · Ridgeland, WIN4759ERatcliff Stephen B · Anchorage, AKN4759JPersons Jonathan B · Eagan, MNN4759LPc 180 LLC · Lincoln, NEN4759MTempel Warren K · Longmont, CON4759NMitchell Robert L · Presque Isle, MIN4759QPease Robert J · Anchorage, AKN4759TPasricha Sarosh K · Swedesboro, NJN475ACWigginton John D · Saco, MEN475AHBoatman John H Jr · Smyrna, TNN475ATAirmen Testing And Training Inc · Lantana, FLN475CDBird 33 LLC · Cody, WYN475CJKing Charles Douglas Sr · Silsbee, TXN475DSLevi Davis LLC · Gratiot, WIN475ECGarcia Paola Olivares · El Paso, TXN475EREmbry-Riddle Aeronautical University · Daytona Beach, FLN475GPBig Sky Communication & Cable Inc · Billings, MTN475JGwaltney Air Inc · Alexander City, ALN475JMSmm Aviation LLC · Destin, FLN475KKmt Aviation LLC · Centerville, OHN475LN475l LLC · Boise, ID
Back to AD 2007-04-19 R1