AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N9577XColumbia Asset Trust Corp Trustee · Wichita, KSN9577YShort Notice Inc · Pensacola, FLN9577ZAtp Aircraft 4 LLC · Wilmington, DEN95785Elton Donald Robert · Kissimmee, FLN95789Katmai LLC · Mount Pleasant, TXN9578BHalseth Harald E · El Paso, TXN9578XTvat LLC · Sun City, AZN9579ABolan Steve A · Concrete, WAN9579EAdventist World Aviation · Wilson, NCN9579VPlaisted Aviation LLC · Elk River, MNN9579XHayden Luke S · Yardley, PAN957CFBergdoll Barry L · Juneau, AKN957DDDon Davis Aviation Inc · Henderson, KYN957DFNorthern Flight Expeditions LLC · Hopkins, MNN957EREmbry Riddle Aeronautical University · Daytona Beach, FLN957ESVolar I LLC · Edmond, OKN95801Abraham James · Johnson City, TNN95802Aircraft Acquisitions Inc · Durham, NCN95807Prostar Flight Services LLC · Bozeman, MTN95808Cape Cod Aero Club LLC · Falmouth, MAN9580BEds Flying Service Inc · Denton, MTN9580XNewman Michael Mcdermott II · Campo, CAN9581ADean Jeffrey · Husum, WAN9581GN9581g Corp · Skokie, ILN9581HCole Jimmie D · Cotopaxi, CON9581VMartin Northern Aviation LLC · Benton, ARN95826Mountain Air Inc · Ducktown, TNN9582HMiller Timothy · Saratoga, CAN9582MAmerican Aviation Inc · Woods Cross, UTN9582VCady Craig D · New Braunfels, TXN95834Herschend James R · Ozark, MON9583BBurke Larry Ryan · Pembroke, GAN9583MUsda Aphis Ppq · Edinburg, TXN95841Para David B Trustee · Prescott, AZN95848Makowski Maciej J · Nipomo, CAN9584APenca Stephen J · Arlington, TXN9584B360 Marine · Bristol, RIN9584QHoward Genetics Inc · Ardmore, OKN9584TBruce Nicholson · Gallup, NMN9584VStick & Rudder Club Inc · Waukegan, ILN95857A & M Airplane LLC · Grover Hill, OHN95858Tucker Thomas O Jr · Austin, TXN9585GBillmyer Services Inc · Friday Harbor, WAN9585VHarrington Aviation LLC · Scarborough, MEN95860Cumberland Air LLC · Stuart, VAN95863Shields Stephen T · Holly Springs, NCN95865Registered aircraftN95868Descco Design & Construction Inc · Fleetwood, PAN9586BAmidon Gary · Shady Cove, ORN9586TRegistration Pending · Talent, ORRegistration pending
Back to AD 79-10-14 R1