AD 76-03-05
Registered aircraft · 913
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:76-03-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-03-05')
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:76-03-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-03-05') 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.
N100FBHoffman Swen · Sedalia, CON100TBAlexander Aviation LLC · Brighton, CON103WWWilkin Richard G · Monticello, ILN105FADebbie Air LLC · Perkasie, PAN106NChenevert Eric M · Clarence, NYN111YBVanicek Nicholas Andrew · Whispering Pines, NCN112GBN112gb LLC · Oldsmar, FLN119JSFennen David A · Katy, TXN122SJDeloof Dion S · Austin, TXN1250YAircraft Guaranty Corp Trustee · Oklahoma City, OKN127BNunneley Ian · Port Saint Joe, FLN1310AKoep Evan T · Brookings, SDN133FCWisdom Blake Andrew · Chapmansboro, TNN1359AJohn Allen Construction LLC · Big Sandy, TNN13RTWoodhouse Dave · Battle Creek, MIN1400GRotor Spec Aviation LLC · Star, IDN1404GJkc Farm LLC · Chinook, MTN1405GLefever Larry R · Fall City, WAN1408GMorris Travis T · Chandler, AZN1412GBruch Lance J · Emmetsburg, IAN1416GNixon Terry L · Enid, OKN1417GRomney James J · Fruit Heights, UTN1419GMcneal James B · Beaufort, SCN141HCKom Terry M · Brandon, MSN141MWSimmons Robert J · Justin, TXN1423GHolscher Barclay M · Amery, WIN1424GLothlorien LLC · Two Harbors, MNN1427GCarter Geoffrey R · Ormond Beach, FLN1430GRoyal Wolf Aviation LLC · Lubbock, TXN1434GWagner Carl · Eagle, IDN1437GMason Mark D · Brighton, CON143MBHughes Kathryn G · Council, IDN1443GLewis Andrew P · Altoona, IAN1444MPhillips Jason Marc · Milford, NJN1446GHangar 46 LLC · Garden City, KSN1447GMutz Richard Douglas Jr · Rockledge, FLN1448GMotions Dynamics LLC · Campbellsville, KYN144FFoster Gary E · Kress, TXN144GMWilliams David · Golden, MON1452GPutnam Mitchell D · Lees Summit, MON1454GN1454g LLC · Knoxville, TNN1455GNell James E · Pagosa Springs, CON1458GBayles Peter T · Sulphur, LAN1459GBeeson Chris · Graford, TXN1464GClauson Edward Ptrust · Charlestown, RIN1470GBaker Dennis J · Shipman, ILN1477GDobson John F · Union, WAN147ETLynch Francis X · Dumont, NJN1482GPwa 1002 LLC · Edmond, OKN1485GHarris John F III · Louisburg, NC
Back to AD 76-03-05