AD 2001-07-11
Registered aircraft · 472
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:2001-07-11')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-07-11')
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:2001-07-11') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-07-11') 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.
N36SPKentucky State Police · Frankfort, KYN37ACAircraft Holding Solutions LLC Trustee · Newark, DEN37BMLas Express Aviation LLC · Las Vegas, NVN382TCSkylink Jets Inc · Fort Lauderdale, FLN384CFMed Air LLC · Wilmington, DEN385RCTms Global Investments Inc · Naples, FLN389AWAir Gato Enterprises Inc · Clearwater, FLN38MGBay Venture Management LLC · Atlanta, GAN38PSAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedN393SCN169px LLC · Delaware, OHN39FNGh Equipment LLC · Dover, DEN400CZDodson International Parts Inc · Rantoul, KSFirst renewal noticeN400MSMil Oh LLC · Camden, DEN405VSCalspan Corporation · Buffalo, NYN406VSCalspan LLC · Buffalo, NYN40LJJcm Aviation LLC · Nashville, TNN412SWThunderforce Investments LLC · Washington, DCN417BARoyal Air Freight Inc · Waterford, MIN418DLRsb Investments LLC · Washington, PAN41GJGlobal Jetcare Inc · Brooksville, FLN41RARoyal Air Freight Inc · Waterford, MIN421SVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN429FCLopez Fabio · Denver, NCN429MSFci Aeronautics LLC · Marble Falls, TXN431CKKalitta Charters LLC · Ypsilanti, MIN431DAAviation Collective LLC · Lewes, DEN433DDE D Santos & Associates LLC · Wilmington, DEN435MSPuragain Water LLC · Escondido, CAN43MFMed Flight Air Ambulance Inc · Albuquerque, NMN4415WDodson International Parts Inc · Rantoul, KSN441PCAero Jet Aviation I Inc · Fort Lauderdale, FLN4447PAviation Management & Repairs Inc · Fort Pierce, FLN444HCPdii LLC · Concord, NCN444TGAmerican Trans Air Training Corp · Virginia Beach, VAN453AMN543am LLC · Englewood, CON456CGLdl Aircraft Leasing LLC · Pittsfield, MAN45ED45ed LLC · Calhoun, GAN45LJWorldwide Aircraft Services Inc · Tampa, FLN460SBIndigo Aviation LLC · Mcallen, TXN469BBCentex Aero LLC Trustee · San Antonio, TXN46MFMed Flight Air Ambulance Inc · Albuquerque, NMN473TCTulsa Technology Center School District #18 · Tulsa, OKN474KAIce9 Lear35 LLC · Boulder, CON477KRegistered aircraftN47MFMed Flight Air Ambulance Inc · Albuquerque, NMN47RARoyal Air Freight Inc · Waterford, MIN480MEMe LLC · Scottsdale, AZN484BATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN48CTBank Of Utah Trustee · Salt Lake City, UTN499BSNational Aviation Academy Of Mississippi Inc · Clearwater, FL
Back to AD 2001-07-11