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.

N192CMFriehe Berend · Moses Lake, WABuilt 1981 · S/N U20606160 N192CRIvas Edward P · Great Barrington, MABuilt 1992 · S/N 92-301016 N192JKWest Gregory B · Cummings, GABuilt 2004 · S/N 29-0353 N192JRCessna 185 LLC · Birmingham, MIS/N 18502286 N1931QKlaes Sheldon T · Fairbanks, AKBuilt 1977 · S/N 18503504 N1932NChubb Stanley C · Mason, MIBuilt 1973 · S/N CE-417 N1932UFryer Charles Trustee · Glendale, AZBuilt 1969 · S/N 18501623 N193DC310 Charter LLC · Zanesville, OHBuilt 1980 · S/N 310R1885 N193DWGilbert Louis Vincent · Houston, TXBuilt 2004 · S/N 42043 N193FBDiamond Sage LLC · Herndon, VABuilt 2000 · S/N 30-0054 N193LBRiverway Capital LLC · Houston, TXBuilt 1976 · S/N 20700360 N193TATuck Aerial Surveys Inc · Big Stone Gap, VABuilt 1980 · S/N U20605946 N193TTBgiii Air LLC · Tampa, FLBuilt 1976 · S/N 21061601 N1942GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0842 N1942XGarrison Weldon · Texarkana, TXBuilt 1979 · S/N P21000296 N1943MBenbrook Robert A · Blairstown, NJBuilt 1977 · S/N 21061968 N1944EHans Construction LLC · Lititz, PAS/N 340A0675 N1944GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0844 N1946GPartwin421 LLC · Greenwich, CTBuilt 1974 · S/N 421B0846 N1947MMoeny James A · Cottonwood, AZBuilt 1964 · S/N D-7547 N1947UTri Pacer Air LLC · Pennington, NJBuilt 1946 · S/N NAV-4-394 N1949SDovetail Aviation LLC · Wilmington, NCBuilt 1977 · S/N E-1011 N194ABennett Jay D · Indian Harbour Bch, FLBuilt 1990 · S/N CE-1465 N194CDLehmar LLC · New Orleans, LABuilt 2004 · S/N 1027 N194NASharrit Edgar W · Sebring, FLS/N D-8409 N194VUphoff Jeffrey A · Roanoke, VAS/N 29-0200 N1950U3 Stones Productions LLC · Anchorage, AKBuilt 1970 · S/N 18501659 N1950XArgyll Aviation II LLC · Kiefer, OKBuilt 1998 · S/N E3174 N1951GClassic Aviation Inc · Pella, IABuilt 2003 · S/N 0630 N1951TBachmann Jochen W · Hudson, OHBuilt 1980 · S/N 185-04134 N1952KWard & Ward Management Consultants Inc · Sparta, TNBuilt 2002 · S/N 0147 N1953UAnstrand Charles Jason · Boise, IDBuilt 1974 · S/N U20602306 N1954LSmith Cody · Fairbanks, AKBuilt 1966 · S/N U2060751 N1954UAircraft Structural Repair Inc · Hamilton, MTBuilt 1970 · S/N 18501665 N195FLInternational Air Services Inc Trustee · Carson City, NVBuilt 1991 · S/N E-2619 N1961UMccarthy Trevor William · Addison, TXBuilt 1974 · S/N U20602312 N1963MN1963m LLC · Torrance, CABuilt 2002 · S/N 0355 N1964ARex Air LLC · Madisonville, LABuilt 1993 · S/N E-2822 N1965SN1965s LLC · Williamstown, NJBuilt 1964 · S/N D-7653 N1965TWeld Kenneth Jr DBA · Port Orange, FLBuilt 1964 · S/N D-7543 N1965ZBushwack Air Inc · Phoenix, AZBuilt 1965 · S/N D-7805 N1968DBellamy Inc · Three Forks, MTBuilt 1968 · S/N TE-576 N1969LBlue Skys Aviation LLC · Wilmington, DEBuilt 2004 · S/N L2K-181 N196CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0116 N196GXRhodes David · Washington, DCBuilt 2006 · S/N 29-0414 N196TCClements Dylan A · Burlington, WIBuilt 1980 · S/N 310R1801 N1970NDaniel Arthur D · Fishtail, MTBuilt 1969 · S/N E-186 N1971VThompson Timothy · Prosser, WAS/N 30395 N1972USparrow Thomas E · Hawley, MNBuilt 1970 · S/N 18501702 N1973Registered aircraftBuilt 1972 · S/N TE-886

Back to AD 86-13-04 R3