AD 76-09-10
Registered aircraft · 65
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:76-09-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-09-10')
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:76-09-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-09-10') 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.
N108AClayton Harry L · Wichita, KSN10LACondon Anthony B · Wichita, KSN1117Lipe James E · Rossville, TNN11SWMetkowski Leonard P · York, PAN13DHenshaw Fritz H · Napa, CAN14JSMcnett Eric V · Topsham, MEN1524TYoung Dennis N · Glen Mills, PAN177RFJones Gary R · Albany, NYN184NHarper Robert J · Broken Arrow, OKN1UDSpontak James S · Etters, PAN22FFWillat Garret I · Warner Springs, CAN230XFWalker Neiman J · Denton, TXN2429Bittner Charles K · Maize, KSN26TEStandish Jason L · Brook, INN271BLVinarub Marc R · Webster, FLN27826Bowen Stephen T · Englewood, TNN279PN279p LLC · Homestead, FLN2866Arnold David A · Jeffersonville, INN3247Bartels Lance R · Freetown, INN333UMason Steven K · Rolla, MON3450GSalmons James B · Oklahoma City, OKN3488Russell Tipton J · Muncie, INN3698Abair Alan A · Cromwell, INN3BJFrazin Michael B · Bend, ORN3WHNorthern California Soaring Association · Livermore, CAN3XACentral Ohio Soaring Association · Columbus, OHN4024Stoltz Charles T · Trenton, MIN411JRCollegiate Soaring Association Inc · Greeley, CON446EOngstad Clifford C · Surprise, AZN468EMoore Michael D · Durham, MEN49765Preston Shane M · Tuttle, OKN4990GHigh Alpine Restaurant Ahcs Inc · Snowmass Village, CON4CCBrown Leslie Albert · Saint Clair Shores, MIN4RFJurado Alfonso E · Miami, FLN511XMackenzie Franklin F Trustee · Cary, NCN55YRArmstrong Gregory A · Bonita, CAN5668Beltz Thomas G Jr · Lehighton, PAN56LSSouthern Eagles Soaring Inc · Butler, GAN581AGMiner Daniel E · Columbus, OHN6483Mrozinski Eric · Westford, MAN6484Gray Thomas M · Magnetic Springs, OHN6485Atkinson Gary R · Pine Grove, PAN6486Rippy Robert · Wichita, KSN6MSStafford Linda J DBA · Ann Arbor, MIN71LSLundin Michael A · Ellensburg, WAN726MCOkeson Trent J · Spring, TXN72ZZRavanfar Kia N · Redondo Beach, CAN777BDFranke Adam M · Eagle, IDN7898Everson John · Providence, RIN8082Worthen David · Las Vegas, NV
Back to AD 76-09-10