AD 2016-05-13
Registered aircraft · 3,126
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:2016-05-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:2016-05-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:2016-05-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:2016-05-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.
N721LAAir Repair Inc · Cleveland, MSN721MBDgw Enterprises LLC · Edina, MNN721RDKing Edward Inc · Cullman, ALN721SRNcs Aviation LLC · Bemidji, MNN72213Skyline Aviation Services LLC · Miramar, FLN722FXFederal Express Corporation · Memphis, TNN722VBCopacetic Air LLC · Rutledge, TNN7230HAb Aviation LLC · Johns Island, SCN723FXFederal Express Corporation · Memphis, TNN723SCRegistered aircraftN724AAAlbright Insurance Holdings Inc · Burlington, NCN724DMBusker Aviation LLC · Detroit Lakes, MNN724FXFederal Express Corporation · Memphis, TNN724HFAir Methods LLC · Greenwood Village, CON724KHCloud Nine Corp · Batesville, INN725FXFederal Express Corporation · Memphis, TNN725LMSimply Living LLC · Fort Myers, FLN725RABar Environmental Supply Inc · Brentwood, TNN726FXFederal Express Corporation · Memphis, TNN726RLLassco LLC · Middletown, DEN727FXFederal Express Corporation · Memphis, TNN728FXFederal Express Corporation · Memphis, TNN729AAAllen Air 2 LLC · Litchfield, MNN729CFWells Flying Services LLC · Holdrege, NEN729FXFederal Express Corporation · Memphis, TNN729GTBig Sky Aviation LLC · Bozeman, MTN729LARice Flying LLC · Corning, ARN729PFRtc Aviation LLC · Munday, TXN72FERegistered aircraftN72JDynamic Avlease Inc · Bridgewater, VAN72KAKenmore Air Harbor LLC · Kenmore, WAN72LXSapient Air LLC · Kirkland, AZN72RARoyal Air Freight Inc · Waterford, MIN73Federal Aviation Administration · Oklahoma City, OKN73005Mid Atlantic Ag LLC · Nassau, DEN73006Mid Continent Aircraft Corp · Hayti, MON7300EMark Gary Flying Service Inc · Inverness, MSN7305GAerial Ag Services LLC · Hillsboro, TXN73070Lake Air Service LLC · Jennings, LAN7307TAas LLC · Ovid, MIN73080Tall Towers Aviation Inc · Page, NDN73084Precision Aerial Ag LLC · Seneca, KSN7308ADevil Dusters Inc · Artesia, NMN730FXFederal Express Corporation · Memphis, TNN7315LSale Reported · Pelkie, MISale reportedN731FXFederal Express Corporation · Memphis, TNN731LMStructure Studios LLC · Henderson, NVN731PBBeaver Creek Aviation LLC · Perry, IAN731TJDcs Air LLC · Lewes, DEN732MDUmb Bank Na Trustee · Salt Lake City, UT
Back to AD 2016-05-13