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.
N421AGone Flyin LLC · Wilmington, DEN421AGFarm Flysician LLC · Ardmore, OKN421AHJ R Herring Enterprises Inc · Wellington, FLN421ARHlc Travel LLC · Perham, MNN421BCSpray Brothers Aviation LLC · Great Bend, KSN421BD421bd LLC · Arab, ALN421BNOne Golden Eagle LLC · Kalispell, MTN421BPMed Jets USA Inc · Boca Raton, FLN421BXCrystal Air LLC · Brighton, MAN421CGMcguire Rick · Liberty, TXN421CKKarow Robert J · Rosharon, TXN421CLEmployment Services Inc DBA · Virginia Beach, VAN421CRPaw Aviation LLC · La Porte, INN421CTArizona Air Salvage · Phoenix, AZN421CXPatriot Aircraft Specialist LLC · Boynton Beach, FLN421DERs Aviation LLC · Wilmington, DEN421DKRegistration Pending · Sonoma, CARegistration pendingN421DMYingling Consultation LLC · Wilmington, DEN421DSN421ds LLC · Villa Rica, GAN421ESmith Russell N · Pensacola, FLN421EEBas Part Sales LLC · Greeley, CON421EQEquus Air LLC · Norman, OKN421EWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN421EZN421ez LLC · Paw Paw, ILN421FAAll In Aviation LLC · Longview, TXN421FMAxis Aviation LLC · Cape Canaveral, FLN421GShapiro David Michael · Homer, AKN421GCBtc Enterprises LLC · Wilmington, DEN421GEMels Priced Right Custom Carts · Lakeland, FLN421GGScientific Flight Corp · Shorewood, ILN421GHArx Aviation LLC · Apopka, FLN421GJAeroventures 8 LLC · Mount Carmel, TNN421GKK2 Aviation LLC · Sanford, NCN421GL421 Partners Georgia LLC · Chatsworth, GAN421GMCjk Investment Holdings LLC · Tallahassee, FLN421GPCircle Capital Industrial Iac LLC · Dover, DEN421GSStarlight Aviation LLC · Houston, TXN421GWGrinnell Allen L · Derry, NHN421HLDodson International Parts Inc · Rantoul, KSN421HPDodson International Parts Inc · Rantoul, KSN421HRRons Air Service Inc · Two Buttes, CON421J421j LLC · Chuckey, TNN421JMSchuck James M · Downey, CAN421JSBank Of Utah Trustee · Salt Lake City, UTN421JTPetty Flying Service Inc · Munday, TXN421JWWheels Up Aviation LLC · Edmond, OKN421KMWeatherproof Montana LLC · Missoula, MTN421KSEnvironmental Manufacturing Solutions Ltd · Melbourne, FLN421LCApi Aviation Leasing LLC · North Venice, FLN421LEN421le LLC · High Springs, FL
Back to AD 75-09-13