AD 81-13-10 R1
Registered aircraft · 4,001
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-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.
N8321XPiper Investments · Visalia, CAN83225Wiser Air LLC · Eastchester, NYN8324CSingh Javier · Atlanta, GAN8325CPecile Nicola · Lancaster, CAN8327BJet & Rotor Aviation LLC · Sacramento, CAN8327HR Darrell Weaver Enterprises LLC · Moore, OKN8328VQuick Gas Aviation LLC · Thomasville, GAN832JAMoore Jimmy L · Beach City, TXN8332BBeckham Brett A · Anson, TXN8334CR & D Aviaton LLC DBA · Atkinson, NEN8335CRegistered aircraftN8335XKenyon Travis · Phoenix, AZN833SCBonet Fernando Andres · Miami, FLN83435Florida Flyers Flight Academy Inc · Saint Augustine, FLN83486Arrow Aviation LLC · Scottsdale, AZN834RVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8350ZBas Part Sales LLC · Greeley, CON8351BPanning Eric M · Portland, ORN8351CSilver Express Co DBA · Miami, FLNon-citizen corporation, flight hours not reportedN83562Wilson Michael · Missouri City, TXN8356XRys Sebastian M · Paterson, NJN8359ESabrilyn Ventures LLC · The Villages, FLN8362DCoco Aircraft Inc · Merritt Island, FLN8362YScherr Steven J · Mandan, NDN836C36c Flights LLC · Ottawa Hills, OHN8371BAdams Bryan J · Mesquite, TXN8372UOgopogo Foundation · Sonora, CAN8375NMackenzie Franklin Arthur III · Lenox, MIN8376GDakota Aircare Inc · Wagner, SDN8377SMiller Devin · Georgetown, TXN837DDKleeman Thomas J · Cooper Landing, AKN8385CPaul David M · Peoria, AZN838RJDicky David J · Sierra Vista, AZN8392TJ & L Flight Ventures LLC · Edgewater, MDN8392VSaunders Robert · Alpharetta, GAN83932Mike Sierra Aviation LLC · Fort Worth, TXN8393YPars Avn Corp · Wilmington, DEN8394ANew Orleans Aviation LLC · Slidell, LAN83956Mc Laughlin Paul E · Mansfield, OHN8398HAircom Mechanical · Milpitas, CAN8399AL C Shearer LLC · Battle Ground, WAN839RDRoyal D Farms LLC · Baytown, TXN83CDRegistered aircraftN83EDRolando Pierluigi · San Marcos, CAN83MFAircraft Guaranty Corp Trustee · Oklahoma City, OKN83RMPemc Air LLC · Evansville, INN8401MRlv Industries Inc · Westerly, RIN8403JBlue Sky Investments LLC · Chokio, MNN8406TCook Neal L · Anchorage, AKN8407FPan Bar Aviation Inc · Pittsburgh, PA
Back to AD 81-13-10 R1