AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N85TROdaniel Trey · Bennington, NEN85TTHerbert Henry W · Lake Stevens, WAN85TXBrown Judy C · Fredericksburg, TXN85TYYoung Thomas M · Homer, AKN85VAAvro Ltd · Grand Junction, CON85WABeckwith James N · Goldsboro, NCN85WEBrooks Matthew · Norman, OKN85WSSouthern Aircraft Consultancy Inc Trustee · Casper, WYN85WYDouble L Air LLC · Missoula, MTN85ZZSpeed Products LLC · Missoula, MTN8600CFowler Leo W · Port Alsworth, AKN8600DPockrus Pat B · Mineral Wells, TXN8600XR1 Aviation LLC · Lake Havasu City, AZN8600YMontcalm Kevin L · Mansfield, LAN8601Lewis Richard F · Halifax, VAN8601AWhitaker Alvin E · Waterloo, WIN8601DRubbert Randy C · Reynolds, NDN8601NLpm Sky Masters LLC · Green Cove Springs, FLN8601WEtten Douglas E · Dalton, MNN8601XHuff Air LLC · Uvalde, TXN8602CShrode Rafe C · Jewett, TXN8602DFithian Cody D · Wasilla, AKN8602KSkywagon LLC · Wilmington, DEN8602SBrodine Alan H · Rochester, NYN8602VSchumaker Daniel J · Glenville, MNN8604WMoore Eric D · Elkhart, TXN8605CColier Neal · Mc David, FLFirst renewal noticeN8605DTroxel Robert G · Parma, IDN8605LMiller Andy D · Marana, AZN8605NTremper John D · Newton, NJN8605VGibney Ricky D · Fargo, NDN8605YFudenberg Elevated Solutions LLC · Las Vegas, NVN8606EJ&H Aviation LLC · Middletown, DEN8607COllmann Paul W · Poplar Grove, ILN8607DDowns Benjamin S · Madison, SDN8607YMs Aero Inc · Lakeville, OHN8608DYoung Mike · Albany, CAN8608VBenter Neil W · Ambrose, NDN8609NBird Properties LLC · Roosevelt, UTN8609VRegistration Pending · Frontenac, MNRegistration pendingN8609WCherokee 8609w LLC · Morgan, UTN860ACAri Ben Aviator Inc · Fort Pierce, FLN860AUAuburn University · Auburn, ALN860CPChristiansen Aviation LLC · Wilmington, DEN860KSKansas State University · Salina, KSN860PARe Elite Aviation LLC · Hialeah, FLN860SASaint Clair Flight Academy Inc · Richmond, MIN860SCFf22 LLC · Scottsdale, AZN860SPRegistered aircraftN860TCNorth Star Aviation Inc · Mankato, MN
Back to AD 81-18-04 R2