AD 94-05-05 R1
Registered aircraft · 26,231
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.
N5471RGq Aviation LLC · Cherry Hill, NJN5471TWiesen Michael J · Waldo, FLN5472QAmf Diversified LLC · Mesa, AZN5473ESitta Donald C · Farmington, NMN5473F8s1-51 LLC · Polson, MTN5473QBell Craig S · Warren, OHN5473RRotormate LLC · Royse City, TXN5474CTrimble Joshua · San Antonio, TXN5474FRaymond Patrick H · Jerseyville, ILN5474RLeone Thomas A · Winchester, VAN5474TTisdell Branden L · Bear, DEN5475CChampagne Richard W · Amelia Court House, VAN5475FWinger Christopher W · Maplewood, MNN5475QParker Jerry F · Mary Esther, FLN5475REllerbee William B · Dothan, ALN5476ENorth Fergus Flying Club · Winifred, MTN5476FHeacock Anthony A · Chino Hills, CAN5477CJohnson John Christian · Coeur D Alene, IDN5477EVolatilis LLC · Wilmington, DEN5477TRegistration Pending · Anchorage, AKRegistration pendingN5478FTompkins Robert George · Frankfurt Am MainN5478RNorcal Flight Center LLC · Lincoln, CAN5478TSipes David · Bolivar, TNN5479ESurmick Chad C · Santa Rosa, CAN547ETBarksdale William S · Pascagoula, MSN547TFGamble Terry L · Florence, ALN5480QNeuman Allen D · Sanger, TXN5481COneill Mark B · Pinckney, MIN5481RBirk Gregory R · Charleston, MON5482FDahlberg David F · Basking Ridge, NJN5482RBrown Wesley P · Gillette, WYN5483FGray Melvin D Trustee · Appleton, WIN5484EHarmon Daniel · Josephine, TXN5484RCarlisle Herbert F · Tulia, TXN5484TWings Den LLC · Wilmington, DEN5485FGarretson Frederick M · Gardners, PAN5485TJohnson Warren A · Delavan, WIN5486CMorsman Dorman J · Oklahoma City, OKN5486FSchmitt Kenneth R · Springfield, ORN5486QAlmeida Donald J · E Bridgewater, MAN5486XStrategic Aircraft Management LLC · Fairbanks, AKN5487CRacoon Aviation LLC · San Antonio, TXN5487QEaton Roger C · Vernon, NYN5488ELancaster Kenneth B · Bremen, ALN5489FBraden John H · Watseka, ILN5489NShannon Harry D · Bartow, FLN5489QSmith Gregory · Athens, GAN5489RBrodmerkel Lisa C · Georgetown, PAN5489TDunn Scott · Warren, OHN548PUBerkey Aviation LLC · Lafayette, IN
Back to AD 94-05-05 R1