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.
N733CHAcc Integrated Services Inc · Milwaukee, WIN733PBw69 Air LLC · Fort Walton Beach, FLN734CBGuardian Flight LLC · Lewisville, TXN736WDCassil Robert B Trustee · San Francisco, CAN73PGFirst Financial Bankshares Inc · Abilene, TXN73RARoyal Air Freight Inc · Waterford, MIN73RFRandigo LLC · Wilmington, DEN73WCWest Coast Aircraft Sales LLC · Santa Ana, CAN740FXFederal Express Corp · Memphis, TNN740LALissie Flying Service Inc · Lissie, TXN741FXFederal Express Corp · Memphis, TNN741WCLynchburg Shipyard Inc · Highlands, TXN744FXFederal Express Corp · Memphis, TNN744MAOctane Addiction Aviation Inc · Augusta, GAN745EALaurel Road Properties LLC · Morehead City, NCN745FXFederal Express Corp · Memphis, TNN745LAKlein Flying Service Inc · Lawrenceville, ILN746FXFederal Express Corporation · Memphis, TNN746LAAnderson Farming Co · East Bernard, TXN747FEFederal Express Corporation · Memphis, TNN747FXFederal Express Corporation · Memphis, TNN748FEFederal Express Corporation · Memphis, TNN748FXFederal Express Corporation · Memphis, TNN749FEFederal Express Corp · Memphis, TNN74GCDiamond Bar LLC · Kirkland, WAN74GJSkydive Greene County · Xenia, OHN74KSR & R Pallet Of Garden City · Garden City, KSN74RFAir Flair Inc · Maurice, IAN75Federal Aviation Administration · Oklahoma City, OKN7500SHill Ag-Air LLC · Bancroft, IDN75090Gasper Air Spray Inc · Crookston, MNN7509VRichard Flying Service Inc · Rayne, LAN7509YAnderson'S Flying Service Inc · Yuba City, CAN750ABNpa Aviation LLC · Lafayette, LAN750DZBranded X LLC · Springfield, ORN750FXFederal Express Corporation · Memphis, TNN750KAN750ka LLC · Wilmington, DEN750KPAircraft Structures International Corp · Enid, OKN750LAWestwind Air LLC · Lake Village, ARN750RCLuke & Payton LLC · Marianna, ARN750SDSkydive Coolidge Inc · Tempe, AZN750SSPacair LLC · Brookline, NHN750TTDodson International Parts Inc · Rantoul, KSN750XLArne Aviation LLC · Suffolk, VAN750ZSouthern Airways Pacific LLC · Addison, TXN751FEFederal Express Corp · Memphis, TNN751FXFederal Express Corporation · Memphis, TNN751KCJ A Peterson Enterprises Inc · Shawnee Mission, KSN752FEFederal Express Corporation · Memphis, TNN752FXFederal Express Corporation · Memphis, TN
Back to AD 2016-05-13