Registered aircraft · 18,497

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

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') ORDER BY n_number

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N45DWLaquerre David E · Old Orchard Beach, MEBuilt 1975 · S/N D-9840 N45EEVazarani Sarah · Concord, MABuilt 1971 · S/N TH-185 N45FMBurgner Vanessa C · Belleville, MIBuilt 1976 · S/N TH-739 N45JNSpotts Marcus P · Nora Springs, IABuilt 2003 · S/N 0489 N45KPColvin Clu D DBA · Big Cabin, OKBuilt 1971 · S/N 401B0201 N45LCBelle Robert M · Tampa, FLBuilt 1979 · S/N E-1600 N45MSBeech Flyers Inc · Champaign, ILBuilt 2001 · S/N E-3384 N45PLLep Holdings LLC · Sheridan, WYBuilt 1987 · S/N CE1167 N45PTCleaver Anthony M · Boulder, COBuilt 1976 · S/N TH-727 N45TAMichalek Construction Inc · Keosauqua, IABuilt 1966 · S/N D-8252 N45TFWave Transportation LLC · Middletown, DEBuilt 1982 · S/N 340A1507 N45USFlight Operations LLC · Hollister, MOBuilt 1977 · S/N CE-722 N45VCHoyos Luis F · Fort Pierce, FLBuilt 1964 · S/N 21058282 N45WWHolmes Bruce Arthur · Maricopa, CABuilt 1977 · S/N E-1203 N45XDSubstation Air LLC · Midvale, UTBuilt 1981 · S/N 21064495 N4600SCozzolino Aerosports II LLC · Indianapolis, INBuilt 1975 · S/N E-771 N4600UDlw Aviation LLC · Missoula, MTBuilt 1983 · S/N 21064789 N4601UChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1983 · S/N 21064790 N4601WMike Papa LLC · Newton, KSBuilt 1980 · S/N P21000622 N4604AThomas Douglas E · Grove City, PABuilt 1970 · S/N E-216 N4604NS O W Aviation LLC · Crystal River, FLBuilt 1980 · S/N 340A1016 N4604QBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 21059504 N4605FSterling Aviation2 Lllc · Boca Raton, FLBuilt 1966 · S/N P206-0205 N4605MJohnson Plane Services LLC · Greenbrier, TNBuilt 1978 · S/N E-1246 N4605QRichs Air Service · Victoria, KSBuilt 1971 · S/N 21059505 N4607F7 Fox LLC · Eugene, ORBuilt 1966 · S/N P206-0207 N4607MClark Jean F Trustee · North Falmouth, MABuilt 1978 · S/N TH-938 N4607QSerrano Lynn A · Casa Grande, AZBuilt 1971 · S/N 21059507 N4608ATriplett Robert J · Cameron, WIBuilt 1970 · S/N E-217 N4608FAdvanced Aerospace Consultants Inc · Boynton Beach, FLBuilt 1966 · S/N P206-0208 N4609MShields David C · Council Bluffs, IAS/N CE-772 N4609UJerden Corp · Overland Park, KSBuilt 1979 · S/N U20605000 N460CBScott Ts Ag-Flyin Inc · Colquitt, GABuilt 1966 · S/N P206-0206 N460CCAmerican Falconry Inc · Dayton, WYBuilt 1966 · S/N 185-0993 N460JPNewman Charles · Petaluma, CABuilt 2003 · S/N L2K-204 N460WWMalibu Ww LLC · Fayetteville, GABuilt 1986 · S/N 46-8608022 N460YRMathias Lee R Trustee · Sebastopol, CABuilt 2009 · S/N E-3890 N4610KAvag Inc · Richvale, CABuilt 1979 · S/N P21000235 N4610WTen Right Aviation LLC · Abbeville, LAS/N TH-1378 N4611EFife Jeffrey Ryan · Seminole, FLS/N 18503813 N4611FRandall Jason · Woodstock, ILBuilt 1966 · S/N P206-0211 N4612KChitiea Andrew D · Centennial, COBuilt 1979 · S/N P21000236 N4613MMott John H · Lafayette, INBuilt 1978 · S/N E-1245 N4615SMurrer Aviation Inc · Canonsburg, PAS/N TH-685 N4615XWaters Aero-Marine Inc · South Thomaston, MEFirst renewal noticeBuilt 1979 · S/N U20605513 N4617WSavoldelli Steven · Los Angeles, CABuilt 1980 · S/N P21000623 N4618MBedrock Siteworks LLC · Coatesville, PABuilt 1978 · S/N TJ-150 N4619MNfv LLC · Helena, MTBuilt 1978 · S/N TH-918 N461AJohnson James Michael · Mount Pleasant, SCBuilt 1967 · S/N D-8392 N461BCB&K Leasing Inc · Nantucket, MABuilt 1992 · S/N TH-1661

Back to AD 86-13-04 R3