AD 2018-04-13
Registered aircraft · 1,373
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:2018-04-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:2018-04-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:2018-04-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:2018-04-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.
N350PHPamplemousse Corp · Wilmington, DEN350PRMmr West LLC · Salem, ORN350RMBeyond Ventures LLC · Ellicott City, MDN350RXRamsey Craig · Santa Rosa, CAN350TTN350tt LLC · Dover, DEN350VJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN350XADodson International Parts Inc · Rantoul, KSN350XJRegistered aircraftN350XKRegistered aircraftN350XXPete Mitchell Aviation LLC · Plantation, FLN351ECE C Aviation Services Inc · Zeeland, MIN351JLLink Snacks Inc · Hayward, WIN351SDDynamic Aviation LLC · Fort Wayne, INN351TSCmfg Life Insurance Co · Madison, WIN351VJBank Of Utah Trustee · Salt Lake City, UTN352ECE C Aviation Services Inc · Zeeland, MIN353PCQuantum Aviation LLC · Tampa, FLN353SFSmithfield Packaged Meats Corp · Smithfield, VAN354ASSoave Aviation LLC · Plymouth, MIN354WGAutomatic Press LLC · Horseshoe Bay, TXN355ZBZimmer Biomet Leasing LLC · Warsaw, INN356MLAviation Travel Ventures LLC · Melbourne, FLN356VJBank Of Utah Trustee · Salt Lake City, UTN357CZCz Equipment LLC · Hollywood, FLN357EEDeployment Logistics LLC · Fort Lauderdale, FLN357KGN357kg LLC · Bluffton, SCN357TWLazer Aviation LLC · Orange Park, FLN357VJBank Of Utah Trustee · Salt Lake City, UTN358MHIci Aviation Leasing LLC · Daytona Beach, FLN358VJBank Of Utah Trustee · Salt Lake City, UTN359GSUS Bank Na Trustee · Hartford, CTN359VJBank Of Utah Trustee · Salt Lake City, UTN35FEFederal Express Leasing Corp · Memphis, TNN360LRegistered aircraftN360VJBank Of Utah Trustee · Salt Lake City, UTN361JLLink Snacks Inc · Hayward, WIN362JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN362LRegistered aircraftN365AVN365av LLC · Chandler, AZN365LRegistered aircraftN365MGTvpx Trust Co LLC Trustee · North Salt Lake, UTN365SCBank Of Utah Trustee · Salt Lake City, UTN3688Umb Bank Na Trustee · Salt Lake City, UTN369LLStrategic Leasing LLC · Seattle, WAN370DPaccar Inc · Seatac, WAN370DBCitation X Parts LLC · Liberty, NCN370ELLge Management Partners LLC · Phoenix, AZN371DBCitation X Parts LLC · Liberty, NCN371JGNih-Aviation LLC · Charlotte, NCN371JLLink Snacks Inc · Minong, WI
Back to AD 2018-04-13