Registered aircraft · 108,408

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:2007-04-19-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:2007-04-19-R1') 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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

N103SJBarnick Air Holdings LLC · Santa Barbara, CABuilt 2000 · S/N 20608101 N103SMHermack John F · Toms River, NJBuilt 1978 · S/N E-1267 N103SPAllen Mark · Waynesboro, VABuilt 2000 · S/N 60306 N103SVSun Valley Aviation Inc · Harlingen, TXBuilt 1998 · S/N 17280534 N103TBSugasa David · Imlay, NVBuilt 1989 · S/N 1078 N103TTAero Dynamics Flying Club Inc · Mulino, ORBuilt 1974 · S/N 28-7505092 N103TXWilliams Bradley H Jr · Charleston, SCBuilt 2001 · S/N 18280984 N103URankin Kenneth · Pinellas Park, FLBuilt 1986 · S/N 585 N103VWVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1957 · S/N 18-5817 N103WCBurklund Joshua S · Milaca, MNS/N 1058 N103WWWilkin Richard G · Monticello, ILBuilt 1961 · S/N CD439 N1040FMarrs Matthew D · Bentonville, ARBuilt 1975 · S/N 18502697 N1040JHefferon John W · Locust Grove, GABuilt 1973 · S/N 40 N1040RRees Christopher · Winston Salem, NCBuilt 1996 · S/N 21008C N1040TTen Forty Tango LLC · Wichita, KSBuilt 1962 · S/N TC-318 N1040UAmerican Aviation Inc · Brooksville, FLS/N 34-7250025 N1040WFoolish Pleasure Aviation Inc · Lewes, DEBuilt 1979 · S/N D-10203 N1040XRacette Robert J Jr · Vienna, WVBuilt 1975 · S/N 28-7515377 N10410Clark George A · Worcester, MABuilt 1975 · S/N 17702321 N10419C Flying K Aviation LLC · Black Hawk, COBuilt 1976 · S/N T21061484 N1041HCentury Flight Systems Inc · Mineral Wells, TXBuilt 1977 · S/N 32R-7780125 N1041MHubbard Bennett L · Piedmont, ALBuilt 1975 · S/N 18264214 N1041QSwaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 28-7716081 N1041SN1041s LLC · Key West, FLBuilt 1977 · S/N 17268658 N1041URegistered aircraftBuilt 1981 · S/N E3B-469 N1041XGyllensten Scott · Guilford, CTBuilt 1975 · S/N 28-7505199 N10420Kinney Powell Mcvay · Coppell, TXBuilt 1975 · S/N 17702324 N10421Registered aircraftBuilt 1997 · S/N 21017C N10422Jackson Benjamin Tillman · Rancho Mirage, CABuilt 2004 · S/N 29-0323 N1042APetrie Michael · Chugiak, AKBuilt 1951 · S/N 18-616 N1042DCarson Roger K · Anthem, AZBuilt 2016 · S/N 80189 N1042JJac LLC · Denham Springs, LAS/N 21024C N1042LHale Cynthia G · Upper Black Eddy, PAS/N 14087C N1042PMcalpine David B · Fort Worth, TXBuilt 1986 · S/N 64-18123 N1042RSale Reported · Los Angeles, CASale reportedBuilt 1971 · S/N TC-1414 N1042SPiper Cameron · Winchester, VABuilt 1977 · S/N 172-68662 N1042TJbr Leasing Inc · Orlando, FLBuilt 1976 · S/N TJ-79 N1042UShackleford Developments Of Sc LLC · Mount Pleasant, SCBuilt 1971 · S/N 34-7250026 N1042XN1042x LLC · Papillion, NEBuilt 1975 · S/N 28R-7535223 N1042ZMatthews Casey B · Belmont, NCBuilt 1997 · S/N 28004C N10438Czerwonka David E · Rumford, RIBuilt 1997 · S/N 21031C N1043FBakkes Francois · Sitka, AKBuilt 1975 · S/N 18502700 N1043JLanmon Herman Jr · Hamilton, TXBuilt 1974 · S/N 127 N1043QRegistered aircraftBuilt 1977 · S/N 28R-7737025 N1043SAmerican Aviator LLC · Newark, DEBuilt 1977 · S/N 172-68679 N1043UClinton Arlys L · Fair Oaks, CABuilt 1946 · S/N 81 N1043WLatitude Aviation LLC · Cedar Rapids, IABuilt 1973 · S/N CE-423 N1043XAustin Security Corp · Battleboro, NCBuilt 1975 · S/N 28R-7535224 N10442Hilty David J · Kodiak, AKBuilt 1957 · S/N 22595 N10445Hartz Mark E · Stuttgart, ARBuilt 1953 · S/N 23397

Back to AD 2007-04-19 R1