AD 82-23-01 R1
Registered aircraft · 3,118
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:82-23-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:82-23-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:82-23-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:82-23-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.
N6969PHart Richard W · Alexandria, VAN696PGreer James E Jr · Summit Point, WVN6974PLiske Robert R · Chesterfield, MIN6978PGallego Victor · Matawan, NJN6981PShakis Bear LLC · O Neill, NEN6982PCapuano Group Inc · Ormond Beach, FLN6983PRegistration Pending · Branchburg, NJRegistration pendingN6984PEnglish John H · Pittsburg, TXN6985PDull Stephen A · Redkey, INN6988PKubitz Wesley M · Laurel, MTN6994PHunt Ray A · Louisburg, NCN6995PInternational Air Services Inc Trustee · Carson City, NVN6996PWelling Charles E III · West Islip, NYN69PDDemray William S · Northville, MIN69RDKrens Janet E · Purcellville, VAN6YLHolman Leasing LLC · Anchorage, AKN6YPAircraft Guaranty Corp Trustee · Oklahoma City, OKN7000YSlowpoke Air LLC · Palm Harbor, FLN7001PPavlusik Tibor · Fort Mill, SCN7002PMonterey Bay Aviation Inc · Watsonville, CAN7003PAviation Career Enrichment Inc · Atlanta, GAN7007PAden Charles L · Hudson, CON7008YHeather Jordan Flying Services LLC · Port Saint Lucie, FLN700KRStrange Jim · Tyler, TXN7010PJuliett Tango LLC · West Rutland, VTN7010YBrown William C Jr · Northville, MIN7011PJapikse Bert · Pawleys Island, SCN7012YBooher Greg F · Livingston, TNN7013PShumock Craig A · Moss Point, MSN7013YHubbard James E · Dover, OHN7014PRyan John David · Fort Rucker, ALN7016PSgroi Eric A · Wentzville, MON7017PDewey J Levie P C · Chino Valley, AZN7017YMccormick Royce DBA · Seminole, TXN7020YMehrhoff Stanley E · Prairie Home, MON7021YShira William G · Savannah, GAN7023YMaki Stephen B · New Port Richey, FLN7024YAnderson David J · Gardnerville, NVN7025PA Precious Life Flight LLC · Bend, ORN7028PNorthern Cape Sea Farms LLC · Cape May, NJN7028YAces High Aviation Corp · Pembroke Pines, FLN7030PMartens And Wyatt Air Service LLC · North Platte, NEN7031PTenkiller Flying Club · Tahlequah, OKN7032PFast Twin LLC · Angola, INN7032YBoonedocks LLC · Valley, ALN7036PPumphrey Vickie E · Devine, TXN7038PDolby Richard C · Payson, AZN7039PClark Ronald F · Mc Cool Junction, NEN7042YMulti Engine Flight Time LLC · St George, UTN7044YMcneely Courtney L · Dallas, TX
Back to AD 82-23-01 R1