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.
N4AFN4af LLC · Conroe, TXN4AHHand Kevin D · Anchorage, AKN4ARN4ar LLC · Marienthal, KSN4CGAffordable Avionics Ind DBA · Chino, CAN4GKDalessandro Janet E · Park Falls, WIN4HAArrington Harold M · Detroit, MIN4LFMacys Flying Service Inc · Tulelake, CAN4MCCoberly Adrian R · Manhattan, KSN4MUBlusky Properties & Investments LLC · Cameron, MON4VWPronk Glen R · Crittenden, KYN4YYWilliams Scott Griffin · Salt Lake City, UTN5000UMci Air LLC · Wilmington, DEN5005JDowding Industries Inc · Eaton Rapids, MIN500AWMcnulty Kim E · Tehachapi, CAN500BMHawkwell Aviation LLC · Stillwater, OKN500CHAchiro David P · Truckee, CAN500CTLac Aero LLC · Liberal, KSN500EBKaizen Aircraft Holdings LLC · Kalispell, MTN500TJAirbyars LLC · Spartanburg, SCN500WPWelker Franklin W · Agoura, CAN501DCExecutive Aviation LLC · Peoria, AZN501KPWasson Ronald L · Colleyville, TXN501SFNomarco Inc · Woodburn, ORN5025WAdvanced Aircraft Engineering Inc · Amelia Island, FLN5026VPiland Kenneth Eldon Jr · Carlsbad, CAN502ATAir Note LLC · Delray Beach, FLN502RARichland Aviation Inc · Sidney, MTN5037QSayler Ben · Thief River Falls, MNN5038JKeystone Aerial Surveys Inc · Philadelphia, PAN503ATRegistered aircraftN5047JAir Transport Arm Of Christ Inc · Hurst, TXN504GLBravo Whiskey Solutions LLC · Brenham, TXN504JWPalmer Gary H · San Juan, TXN505CNLes Amis Air LLC · Dorado, PRN505LTLaufer Air Inc · Hartford, WIN505SFLux William E · Newman Lake, WAN5061QLepper Michael J · Ward, CON5062HCoati Aviation LLC · San Diego, CAN5072CThomas Robert Allan Jr · Phoenix, AZN5073CInternational Air Services Inc Trustee · Carson City, NVN5075YAlkota Of Kansas LLC · Wichita, KSN507HHGrossetete Nugget S · Edgewood, NMN5083JKrs Aerial Inc · Galloway, OHN5083TClaar Brian · Spring, TXN5083WJtc Investments LLC · Tyrone, GAN5089C5089c LLC · Fairhope, ALN508TCFisher Travis L · Odessa, TXN50901United Indian Missions Inc DBA · Tucson, AZN5091CMartin Steven J · Phoenix, AZN5098QM&L Engine LLC · Schriever, LA
Back to AD 75-09-13