AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N9431MMeridian Airport Authority · Meridian, MSN9431XShives Investments LLC · Zavalla, TXN94328Gottschalk John R · Atwater, CAN9432CTexas Co Title Inc · Kalispell, MTN9432MRound Table Aviation LLC · Munster, INFirst renewal noticeN94334Play For Today LLC · Michigan City, INN94338Auto Action LLC · Peralta, NMN9433MDels Inc · Mountain Home, ARN9433RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN9433TDoyle Victoria L · Salem, ORN9433XVorlander Daniel S · Mount Pleasant, SCN9434594345 LLC · Ashaway, RIN9434TChurch Philip M · Statesville, NCN94359Jbm Enterprises LLC · Bristol, RIN9435CBackcountry Adventures LLC · Big Lake, AKN9435MEngelhardt Angelo Lomeli · Spring, TXN9436MIkg Air LLC · Page, AZN94371Coppage Farm Services Inc · Braggadocio, MON9438CKrupinski Floyd M · Chugiak, AKN9438MIdaho Transportation Department · Boise, IDN9438TBray Max W Jr · Dora, ALN94391Gall Michael R · Breckenridge, CON9439CYellowstone Overflight Inc · Belgrade, MTN9439XBallard Richard D · Juneau, AKN9439YR C S Drilling Company Inc · West Lake Hills, TXN943AHHaley Keith · Tonawanda, NYN943CPCivil Air Patrol · Maxwell Afb, ALN94405Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN9440XMountain Flyers Inc · Asheville, NCN9441MGuemes Aloft LLC · Portland, ORN9441TDevil Dusters Inc · Artesia, NMN9441XMurphy Peter D · Santa Fe, NMN9441ZTjb Capital LLC · Nashville, TNN9442RPauly Jeff D · Watkins, MNN9443CRvest Management LLC · Boulder City, NVN9444MTriple Four Mike LLC · Sand Springs, OKN9445CSchaller Lee W · New Athens, ILN9445MSky Masters Aviation Inc · Laguna Hills, CAN9445THale Tom · Browns Valley, CAN9446CAlaskan Luxury Cruises LLC · Willow, AKN9446GStringfellow Regan M · Boerne, TXN9447MWings Aircraft LLC · New Richmond, WIN9447XKaminski Thomas E · Green Bay, WIN9448CAero Marine Inc · Westland, MIN9448MSoto Eduard D Trustee · Somers, MTN9449XBelk Pritchard Properties LLC · Broken Arrow, OKN944JHHiggins James R · Camargo, ILN944PMGasper Air Spray Inc · Crookston, MNFirst renewal noticeN944WBSchultz Jason G · Crowley, LAN9450EAivcon Inc · Charlevoix, MI
Back to AD 84-10-01 R1