AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N83082Olson Owen B · Jamestown, NDN83083Melvin John N · Bryan, TXN83088Merrell Robert H · Farmington, NHN8308APrice Jerry A · Joiner, ARN8308BBerg Timothy J · Neenah, WIN8308GThompson Stephen A · Murphy, NCN8308TRegistration Pending · San Tan Valley, AZRegistration pendingN8309GWoods Allen D · Old Hickory, TNN8309TMudd Robert John · Moriarty, NMN8310ARodabaugh Ernest R IV · Greenfield, INN8310JWerth Thomas A · Seattle, WAN8310MFlying Engineers Inc · Indianapolis, INN8310UUnderwood Michael D II · Piney Flats, TNN8310XBarah Inc · Wilmington, DEN83119Ricard John E · Albany, MNN8311BSills Joseph G · Giddings, TXN8311GLockwood William E · Carmel, NYN8311JD T Flying Inc · Okeene, OKN8311UVendetta Consulting LLC · Bellevue, NEN83124Gullett Samuel H · Lafayette, LAN83129Murray Richard H · Celina, OHN8312BCheatham Harold Joseph · San Diego, CARegistration revokedN8312GYampolskiy Dmitriy · San Pedro, CAN8312URowe John R · Stevens Point, WIN8312XPangerl Gary D · Mara, MNN8313USchmidt Jeffrey L · Granbury, TXN8313XJones Brian R · Turlock, CAN83147Clardy E Dennis · Mountain View, ARN8314AMagliacano Matthew J · Bucyrus, KSN8314HPrs Services Inc · Spring Hill, FLN8314TMt Pleasant Aero Club LLC · Mount Pleasant, MIN8314USchmidt Roger W · Wood River, NEN8314XEramo Jennilee · Fayetteville, NCN8315GNaisby Walter H · Harvey Cedars, NJN8315XRozhon Richard J · Valparaiso, INN8316BHudspeth Steve A · Wasilla, AKN8316TKingdom Air Corps · Sutton, AKN8317ASpivey Kenneth R Jr · Vestavia, ALN8317HFolbre Frank S III · Millsap, TXN8317JHinojosa Edward · Georgetown, TXN8317URiver International LLC · Orlando, FLN8317XLittle Air Dream LLC · Mooresville, NCN8318BRegistration Pending · Redondo Beach, CARegistration pendingN8318JGreat Lakes Air Ventures LLC · Mason, MIN8318UBeattie Steven K · Colville, WAN8319AWhitney Bill · Anacortes, WAN8319BLobue Andrew N · Gresham, ORN8319HValente Cornejo Jose · Scottsdale, AZN831BMorrison Ronald J · Murfreesboro, TNN831NCCole Curtis J · Loveland, CO
Back to AD 94-05-05 R1