Registered aircraft · 13,518

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

N6048SWhatley Properties LLC · Muskogee, OKS/N E2061 N6049EBeale Paul D · Longmont, COBuilt 1959 · S/N D-5982 N6049FBrown Boot Aviation LLC · Chesapeake, VABuilt 1965 · S/N D-7820 N6049LExecutive Flight Institute LLC · Murrieta, CABuilt 1979 · S/N ME-202 N604TTaxman Arthur Michael · Port Orange, FLBuilt 1958 · S/N D-5535 N60500Erda LLC · Wilmington, DES/N P-500 N60501Big Bend Community College · Moses Lake, WABuilt 1979 · S/N M-2138 N60503Big Bend Community College · Moses Lake, WABuilt 1979 · S/N M-2170 N6050EJohnson Jay L · Hillsboro, MOBuilt 1959 · S/N D-5977 N6050MAgl Aviation And Management LLC · Payson, AZBuilt 1979 · S/N E-1632 N6050TGullett Aviation LLC · Palatka, FLBuilt 1979 · S/N E-1488 N60519Bunn Robert Michael Trustee · Salina, KSBuilt 1980 · S/N E-1687 N6051MEbe Inc · East Moline, ILBuilt 1979 · S/N E-1492 N6051SCya Aviation LLC · Estero, FLBuilt 1975 · S/N P-372 N60520Kemp Charles Wilson · Richmond, VABuilt 1979 · S/N TC-2227 N60526Sch Aviation Inc Owner Trustee · Sporle Kings LynnS/N TE-1159 N60527Smith Sidney R Trustee · Rllng Hls Est, CABuilt 1979 · S/N D-10235 N6052NRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1968 · S/N M-1159 N6052SCrosswinds Flight Center Inc · Drums, PABuilt 1979 · S/N CE-855 N6053EDublin Airforce LLC · Dublin, GABuilt 1959 · S/N D-5992 N6053NErickson Robert · Otis Orchards, WABuilt 1968 · S/N M-1160 N6054DBrookshier Delbert L · Comanche, TXBuilt 1979 · S/N CE-856 N6054EKj & J LLC · Lamar, MOBuilt 1959 · S/N D-6001 N6054M6054m LLC · Morrison, ILBuilt 1979 · S/N E-1500 N6054NPees Philip G · Concord, NCBuilt 1968 · S/N M-1161 N6055EBurns Ortis R · Warner Robins, GABuilt 1959 · S/N D-6010 N6055JElkhorn Valley Aviation LLC · Fremont, NEBuilt 1979 · S/N TE-1160 N6056YDiesel Flying LLC · Wilmington, DEBuilt 1979 · S/N D-10242 N6057DValentine Jimmie L Trustee · Frisco, TXBuilt 1979 · S/N TC-2233 N6057EPeterson Kenneth M · Henderson, NVBuilt 1959 · S/N D-5989 N6057SRamelow Noyan · Seabrook, TXBuilt 1976 · S/N TJ-45 N6058EBrandt Glen L · West Bend, WIBuilt 1959 · S/N D-6025 N6059EWiseth Kurt C · Thief River Falls, MNBuilt 1959 · S/N D-5988 N6059SGallardo Jorge Luis Marquez · El Mirage, AZS/N TJ-49 N605KParlier Jacob B · Ashland, ILS/N D-3907 N6060YN6060y LLC · Friendswood, TXBuilt 1981 · S/N P-568 N6060ZDesert Aero LLC · Hobbs, NMBuilt 1984 · S/N E-2155 N6061EChase William B · West Des Moines, IABuilt 1959 · S/N D-5996 N6064EBeauboeuf Jeffrey M · Woodworth, LABuilt 1959 · S/N D-5995 N6064SYasechko James Edward · Bonaire, GABuilt 1975 · S/N D-9819 N6065SEdwards Aviation LLC · Fresno, CABuilt 1975 · S/N CE-613 N6066NPacific Union College · Angwin, CABuilt 1968 · S/N MB-398 N6067NGustavson Allan R Jr · Tonopah, AZBuilt 1968 · S/N MB-391 N6067SCanterbury Ventures LLC · Litchfield Park, AZBuilt 1975 · S/N CE-614 N6067TSullivan Patrick V · Chicago, ILBuilt 2002 · S/N E-3467 N6068NVan Steenburgh Owen Christopher · Manitowoc, WIBuilt 1968 · S/N MB-392 N6069SNelson Ronald E · Richmond, TXBuilt 1975 · S/N D-9821 N606BCBell Camp Inc · Lubbock, TXFirst renewal noticeBuilt 1980 · S/N EA-72 N606ERHansen Justin L · St George, UTS/N MB-397 N606REPebblebrook Aviation LLC · Ellinwood, KSBuilt 1982 · S/N TJ-430

Back to AD 99-05-13 R1 WD