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.
N7140QMagnuson Jessica M · Olathe, KSN7140SRegistration Pending · Bermuda Dunes, CARegistration pendingN7141AFarruggia John A · West Winfield, NYN7141CLongview Iron LLC · Longview, TXN7141EBobek Janice C · Soldotna, AKN7141GDyke Paul A · Hartford, SDN7141JHutt Aviation Inc · Minden, NVN7141QFlight Time Builders Inc · Memphis, TNN7141TRosser David S · Lynn, ALN7141XWells Brent R · Atascadero, CAN71420Yeti Aviations LLC · Madison, ALN7142EDuncan Wayne K Trustee · Athol, IDN7142QObymachow Richard M · Killingworth, CTN7142RWirick Neil · Cable, OHN7142XTownsend Charles D · Portage, MIN71430Princeton Raptors Flying Club · Princeton, MNN7143EPfisters Flying Wahine LLC · Waialua, HIN7143GAllen Nathanael W · Bemidji, MNN7143MMiles Richard B · Lompoc, CAN7143QMcgraw Warren R · Pineville, WVN71444Rushville Flying Club Inc · Rushville, ILN7144GJc Flight Inc · Wilmington, DEN7144MKeno Dale J · Worley, IDN7144QJungle Breezes Youth Ministries · East Earl, PAN7144SLet There Be Flight LLC · Portage, MIN71450Ejs Enterprises Inc · Three Forks, MTN71452Blay Jeffrey E · Oak Harbor, OHN7145EJones Robert · Anchorage, AKN7145QEdling Tyrell R · The Dalles, ORN7145TZacharias Norman R · Hinckley, MNFirst renewal noticeN7145XAthol Orange Aero Club Inc · Athol, MAN71462Shaffer Jessie J · Peyton, CON71463Rodrigo Jodi L · Orland, CAN7146FR And R Plane LLC · Lewiston, IDN7146GHalladay Roy · Erie, CON7146MWright Roy E · Tulelake, CAN7146QPressley Aviation LLC · New London, NCN7146YRoberts George M · Houston, TXN7147AAir Cover Academy LLC · Frankford, MON7147FHernandez Jorge L · Luthersville, GAN7147GAffordable Flying LLC · Cedar Park, TXN7147TMoody George A II · Dyersburg, TNN7147XBrooks Blaze W · Fairbanks, AKN71484Noss David L Jr · Hominy, OKN7148EBush Dale L · Medford, ORN7148FHigh Flight Aviation Of Kentucky Inc · Lexington, KYFirst renewal noticeN7148QRosevelt Jane · Lake Oswego, ORN7148SJupiter Flight Service And Investing LLC · Lithonia, GAN7148XLong Thomas S · Longview, TXN71491Kelley Philip W · Titus, AL
Back to AD 79-10-14 R1