AD 75-09-13
Registered aircraft · 4,787
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-09-13')
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-09-13')
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-09-13') 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-09-13') 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.
N320HHartwell John E · Pleasanton, CAN320JZBas Part Sales LLC · Greeley, CON320KChisum Robert W · Lorenzo, TXN320MSConsulat Inc · Cheyenne, WYN320PCAom Aircraft LLC · Wilmington, DEN320PPIpock Brian P · Tulsa, OKN320RDBurwell Michael · W Bloomfield, MIN320RMRd Harrison Inc · Lexington, NCN320SKDevries James E · Bejou, MNN320TJBlaylock Arthur S III · Pace, FLN320TTCarroll Richard J · Pocatello, IDN320VCDelta Three Air Services Inc · Burton, OHN3210PKilcullen Brian DBA · Fort Lauderdale, FLN3212DHalo Aviation Corp · Wilmington, DEN3212GGibby Aviation Inc · Wilmington, DEN3216MN3216m Inc Trustee · Carson City, NVN321BLWalls Bruce · Middletown, OHN321CEGreen Eggs And Ham Aero LLC · Helena, MTN321DDGreene Jonathan U · Pompano Beach, FLN321HDodson International Parts Inc · Rantoul, KSN321HASkytook LLC · Wilmington, DEN321JHSkidmore Gary DBA · Terreton, IDN321JRAcademy Aviation Services LLC · Cedar Park, TXN321JTPcss Aviation LLC · New Albany, MSN321LGLaughing Gull Aviation Inc · Fort Lauderdale, FLN321RPIsrael Oscar M III · Sinton, TXN3222PAmlz Air LLC · Rockville, MDN322CCoffman Robert P · Bigfork, MTN322LKFindley Air LLC · Temecula, CAN322RMPhillips George Thomas · Carson City, NVN3233LMann Aviation LLC · Wilmington, DEN3235TBhatia Kabir · Lake Oswego, ORN3236ZJuliet Sierra Foxtrot LLC · Denver City, TXN323DASky West Aviation Inc Trustee · Albuquerque, NMN323DCFlymax Aircraft LLC · Ball Ground, GAN323FLSch Aviation Inc Trustee · Sporle Kings LynnN323PMSrc Property LLC · Alpine, TXN323RCTigers Aviation LLC · Wasilla, AKN323TJGuardian Wings LLC · Fredericksburg, VAN3243COrthopaedic Surgery Institute Of California Mc · Newport Beach, CAN3247PCary Leasing & Management LLC · Boerne, TXN3251WCorporate Flight Mangement LLC · Dallas, TXN325DDQuick Michael D · Middletown, CAN325KCMount Wilson Holdings LLC · Orange, CAN325RPN325rp Corp · Willow Spring, NCN3279NTips Frederick J III · San Antonio, TXN327BWCessna N327bw LLC · Telluride, CON327MWW. Morrison Consulting Group Inc · Aliso Viejo, CAN327TALeblanc Joseph E Jr · Houston, TXN3288MClute Kenneth N · Las Vegas, NV
Back to AD 75-09-13