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.

N4829JMidwest Aircraft Services Inc · Wilmington, DEBuilt 1966 · S/N CE-117 N4829KCanal Flight LLC · Portland, ORBuilt 1979 · S/N P21000337 N482CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1482 N482KBBethune Kenneth · Huntsville, ALBuilt 2021 · S/N ES-138 N4830KRamaker LLC · Choteau, MTBuilt 1979 · S/N P21000338 N4830VAkin Allen Kent · Midland, TXBuilt 1968 · S/N 30095 N4831FWillis Rodney S · Wasilla, AKBuilt 1966 · S/N U206-0531 N4831JSiewert Michael H · Columbus, OHBuilt 1966 · S/N D-8335 N4831MBoty Aero LLC · Madison, ALBuilt 1978 · S/N E-1273 N4833AEnoch Mark C · Rowlett, TXBuilt 1980 · S/N 340A1026 N4833CRossi A F · Belmont, CABuilt 1974 · S/N 18502601 N4834CIverson Paul · Lima, MTBuilt 1975 · S/N 18502602 N4834KBurke Kenneth V · Payson, AZBuilt 1979 · S/N P21000340 N4834QWavra Mark F · East Grand Forks, MNBuilt 1976 · S/N 18802570T N4834WParker Larry C · Roswell, NMBuilt 1980 · S/N P21000627 N4835FHernandez Christopher A · Phoenix, AZS/N U206-0535 N4836CSearfus Kirsten L · Durango, COBuilt 1974 · S/N 18502604 N4836FGold River Aviation LLC · Rio Verde, AZBuilt 1966 · S/N U206-0536 N4836QMcinelly Leon · Fairbanks, AKBuilt 1978 · S/N 18503561 N4837ALongleaf Wing Ventures LLC · Birmingham, ALBuilt 1978 · S/N 414A0101 N4838KCommercial Tenant Improvement Corp · Alta Loma, CABuilt 1979 · S/N P21000341 N4839JFlying For Fun LLC · Sunnyvale, TXBuilt 1966 · S/N D-8340 N483DMN483dm LLC · Hummelstown, PABuilt 1975 · S/N 21060819 N483JFKg Aviation LLC · Huntington, WVBuilt 1974 · S/N 414-0537 N483MMWestern Rivers Aircraft LLC · Paducah, KYBuilt 1977 · S/N 421C0314 N4841CTreftz Kurt B · Anacortes, WAS/N 18502609 N4841RBlack Gulch Aviation LLC · Polson, MTBuilt 1975 · S/N 18802360T N4842JTayrien Jacob A · Queen Creek, AZBuilt 1966 · S/N CE-123 N4842KKinetic Group LLC · Eagle, IDBuilt 1979 · S/N P21000343 N4842QBlack Gulch Aviation LLC · Polson, MTBuilt 1976 · S/N 18802578T N4843CPayne Thomas E · Old Forge, NYBuilt 1975 · S/N 18502611 N4843RFriesenborg & Larson Custom Spraying Lc · Buffalo Center, IABuilt 1975 · S/N 18802362T N4844KMccoy Robert G Jr · Marshville, NCBuilt 1979 · S/N P21000344 N48458Peterson Timothy R · Monument, COBuilt 1971 · S/N D-9291 N4845CBloss Albert P · Seattle, WABuilt 1979 · S/N 21063642 N4845EEllis Jeffrey · Davis, ILBuilt 1979 · S/N 18503887 N4847JLittle River Corp · Anchorage, AKBuilt 1966 · S/N D-8346 N4847VNutter Michael S · University Place, WABuilt 1968 · S/N 30102 N4849JEast Side Mosquito Abatement District · Modesto, CABuilt 1981 · S/N 18803773T N4849QSouther Field Aviation Inc · Americus, GABuilt 1976 · S/N 18802585T N484DAlman Inc · Fort Lauderdale, FLBuilt 1992 · S/N CE-1699 N484JRC L Farwell Holdings III LLC · Brookline, NHBuilt 1966 · S/N CE-120 N484KWNunez-Fontes Fernando · Rio Rico, AZBuilt 1980 · S/N 21064066 N484SWElsass Aviation LLC · Fayetteville, ARBuilt 1980 · S/N 414A0497 N4850JCardamone Rayner Mark Gibson · Manistique, MIBuilt 1966 · S/N D-8345 N4851JAbernathy Spraying Service Inc · Tipton, OKBuilt 1981 · S/N 18803774T N4852ESproul David Douglas Jr · Heath, TXBuilt 1979 · S/N 18503888 N4852JStoffel Christopher David · Colorado Springs, COS/N D-8349 N4853CIdaho Flying Service LLC · Kamiah, IDS/N U20603851 N4853JNaca 130 LLC · Cameron Park, CABuilt 1966 · S/N D-8350

Back to AD 86-13-04 R3