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.
N545DLPnc Financial Services Group Inc · Pittsburgh, PAN545XJBank Of Utah Trustee · Salt Lake City, UTN546FXPleasure Point Associates LLC · Cleveland, OHN546XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN547FXFlexjet LLC · Cleveland, OHN547XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN548XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN549FXCitation X Parts LLC · Liberty, NCN549XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN54CACaptive-Aire Systems Inc · Raleigh, NCN54ENErgon Oil Purchasing Inc · Jackson, MSN54HAL&D Air LLC · Minneapolis, MNN54PPolaris Industries Inc · Medina, MNN54PMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN54RJSanctuary Partners LLC · Ball Ground, GAN54ZSSuplay 5 LLC · Stamford, CTN550ATAssociated Aviation Ventures LLC · Convent, LAN550BARegistered aircraftN550FXFlexjet LLC · Cleveland, OHN550HDSmtm Aviation LLC · Wilmington, DEN550KLRegistered aircraftN550LGBig Country Air LLC · Fargo, NDN550XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN551FXFlexjet LLC · Cleveland, OHN551XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN552FXCitation X Parts LLC · Liberty, NCN552XJBank Of Utah Trustee · Salt Lake City, UTN553FXCitation X Parts LLC · Liberty, NCN555JAJohnson Air LLC · Midland, TXN556DDDelta Aviation LLC · West Bend, WIN556FXFlexjet LLC · Cleveland, OHN557FXVjam LLC · Cleveland, OHN557XJBank Of Utah Trustee · Salt Lake City, UTN558FXFlexjet LLC · Cleveland, OHN558TCRegistered aircraftN559FXFlexjet LLC · Cleveland, OHN55ALKrt LLC · Greenwich, CTN55EBBank Of Utah Trustee · Salt Lake City, UTN55GPCox Aviation LLC · Atlanta, GAN55NGOlympus Equipment LLC · Newport Beach, CAN561FXFlexjet LLC · Cleveland, OHN562FXFlexjet LLC · Cleveland, OHN563FXFlexjet LLC · Cleveland, OHN565ABCca Holdings LLC · Richmond, VAN565FXFlexjet LLC · Cleveland, OHN566FXFlexjet LLC · Cleveland, OHN567FXStair LLC · Cleveland, OHN568FXJc Investco LLC · Cleveland, OHN569FXBbd Ventures LLC · Cleveland, OHN56BACore Natural Resources Inc · Canonsburg, PA
Back to AD 2018-04-13