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.
N59EPP77 LLC · Ketchum, IDN59JSValiair Lc Trustee · Casper, WYN59KGRegistered aircraftN59MGHedwig 1 LLC · Wapiti, WYN5LAir Sansone LLC · Wilmington, DEN600ARSel Aircraft LLC · Bristol, INN600AWRegistered aircraftN600CFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN600CHAllegiance I LLC · Columbus, OHN600DHDrury Development Corp · St Louis, MON600FXFlexjet LLC · Cleveland, OHN600HZBank Of Utah Trustee · Salt Lake City, UTN600JTMountain Air Charter LLC · Dallas, TXN600NXAkima LLC · Herndon, VAN600RXDynasty Jet LLC · Naples, FLN601FXGillman Chris · Cleveland, OHN602FXFlexjet LLC · Cleveland, OHN603FXFlexjet LLC · Cleveland, OHN603GPN603gp LLC · Dover, DEN603HC13400 South 54 Holdings LLC · Lincoln, NEN604DDominion Energy Services Inc · Richmond, VAN605FXFlexjet LLC · Cleveland, OHN605HPPalmetto Express Company LLC · Wilmington, DEN606AFVela Flight LLC · Camarillo, CAN606FXMalayer Management Sub I LLC · Cleveland, OHN606RPSydes Aviation LLC · Jacksonville, NCN607DXDsg Finance LLC · Coraopolis, PAN607FXClinical Ventures Group II LLC · Cleveland, OHN607GJGabinoah LLC · Miami Beach, FLN608ABCl350 20589 LLC · Missoula, MTN608FXFlexjet LLC · Cleveland, OHN608KHIronwood Sky Holdings LLC · Wilmington, DEN608RPWheels Up Partners LLC · New York, NYN608TBFsi Inc · Portage, WIN609FXGriffin Capital LLC · Cleveland, OHN60CKJurie Jet LLC · Frederick, MDN610CGMac Air LLC · Sellersburg, INN610DPWestair Corp · Lexington, SCN610FXRoger Ferris & Partners LLC · Cleveland, OHN610HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN611AVCyprus Center Services LLC · Gilbert, AZN611FXMobiscrypt LLC · Cleveland, OHN612FXAeromarine Holdings LLC · Cleveland, OHN613FXAir Dragon LLC · Cleveland, OHN613LSCarlton Place Leasing LLC · Boca Raton, FLN614FXBird By Bird LLC · Cleveland, OHN614THThorpe LLC · Jupiter, FLN614WDCharlie 350 LLC · Columbus, OHN615TKMash Aviation LLC · Nashville, TNN615WDCharlie 300 LLC · Columbus, OH
Back to AD 2018-04-13