AD 77-13-21
Registered aircraft · 3,193
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:77-13-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
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:77-13-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21') 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.
N7013PShumock 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, FLN702JDCrossbow Aviation LLC · Reno, NVN7030PMartens 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, TXN7046PComanche Aviation LLC · Davie, FLN7047PHirkala Ronald R · New Cumberland, WVN7047YJenkins Joe C · Wyoming, DEN7048PGerard Garrett · North Bend, OHN7050PBork Joseph L · Mosier, ORN7050YTonys Aerial Service Inc · Great Bend, KSN7052PFlying Great Danes LLC · Chesapeake, VAN7053PManter Earl F · Delaware, OHN7054YNordman Clay L · Catheys Valley, CAN7055PKehrle Betty M · Chandler, AZN7056PSelf Melvin Lamar Jr · Greenwood, MSN7059PProx Jonathan P · Enterprise, ALN7059YPhill-Air Inc · Dover, DEN7061YHoistad Flying Service Inc · Forman, NDN7062YFox Norman A · Maryville, TNN7065PReno Joshua · Krum, TXN7066PEckel Kenneth · Hernando, MSN7067YCactus Skybolt Aviation LLC · Athens, ALN7068PLs Engineering Inc · Salt Lake City, UTN7068YAdvanced Aircrew Training LLC · Nashua, NHN7069PD And S Neotech Inc · Ogden, UTN7070PHytry Randal G · De Soto, WIN7070YBean James P · Tulsa, OKN7071PNelson Harold G · Pendleton, ORN7071YJts Aircraft LLC · Rock Hill, SCN7072PRegistration Pending · Kalispell, MTRegistration pendingN7073PPeavy Jason L · Waco, TX
Back to AD 77-13-21