Registered aircraft · 108,433

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.

N2352ZPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-8054022 N23534Schwabenton William J · Greensboro, NCBuilt 1977 · S/N CE-751 N2353COverly Terrence Lee · Tok, AKBuilt 1953 · S/N 30653 N2353GCascade Aero LLC · Scotts Mills, ORS/N 51653 N2353JWings Of History Air Museum · San Martin, CABuilt 1963 · S/N M-311 N2353KGraff Lars U · Kohler, WIBuilt 1998 · S/N 18280420 N2353XB R Trucking LLC · Cut Bank, MTBuilt 1956 · S/N 18-4239 N23540State Of Iowa · Iowa City, IABuilt 1977 · S/N E-1180 N23541Registration Pending · Middleburg, FLRegistration pendingBuilt 1977 · S/N E-1182 N23542Mrj Aviation LLC · Attica, NYBuilt 1977 · S/N D-10085 N2354BHigh Sky LLC · Rogers, ARBuilt 1968 · S/N D-8831 N2354CMoma Donald R · Wasilla, AKBuilt 1953 · S/N 30654 N2354DRegistered aircraftBuilt 1952 · S/N 20506 N2354EGaruda Flight Training LLC · Miami, FLBuilt 1979 · S/N 172-72777 N2354FBarbee William Terry · Weslaco, TXBuilt 1998 · S/N E-3154 N2354GJbtg LLC · Poplar Bluff, MOBuilt 1958 · S/N 51654 N2354RCarter Bradford J · Rockland, MEBuilt 1964 · S/N 18255454 N2354TDiaz Mark A DBA · Madera, CAS/N 2247 N2354XNorth Coast Aeronautical LLC · Cleveland, OHBuilt 1965 · S/N 18256254 N23551S&M Aviation (A Co Limited Liability Co) · Colorado Springs, COBuilt 1977 · S/N E-1183 N23556Aerospring Leasing LLC · Wasilla, AKBuilt 2005 · S/N 172S10095 N23557Flying Dutchman LLC · Wilmington, DEBuilt 2005 · S/N 172S10096 N2355CFerguson Edward P · Fargo, NDBuilt 1953 · S/N 30655 N2355EAce Of Spades Aviation LLC · Las Vegas, NVFirst renewal noticeBuilt 1978 · S/N 17271248 N2355HJohnson Scott · Wasilla, AKBuilt 1979 · S/N 18-7909175 N2355QKreek Karl · Glasgow, KYBuilt 1963 · S/N M-423 N2355RLima Mike Inc · Ham Lake, MNBuilt 1964 · S/N 18255455 N2355TBe-3195 LLC · Conway, ARBuilt 1998 · S/N E-3195 N2355XVan Every Jason E · Cleburne, TXBuilt 1965 · S/N 18256255 N2355YSchwarz Enterprises LLC · Huntington Beach, CABuilt 1967 · S/N 17700155 N2356Dunn Cole E · Florala, ALBuilt 1973 · S/N 17261946 N23566Sunrise Aviation Inc · Ormond Beach, FLBuilt 2005 · S/N 172S10097 N2356EHock Aviation LLC · Stuart, FLBuilt 1999 · S/N 18280423 N2356GKajans Donald F · Reno, NVBuilt 1958 · S/N 51656 N2356JN2356j LLC · Winchester, VABuilt 1963 · S/N M-314 N2356LCircle B Pipe & Supply LLC · Odessa, TXBuilt 1998 · S/N 18280425 N2356MN112vg LLC · Princeton, NJBuilt 1993 · S/N 2262 N2356PJohnson Terry M · Wolfforth, TXS/N 18-4242 N2356RBledsoe Charles J · Jackson, GABuilt 1964 · S/N 18255456 N2356YCulver Lane M · Laceys Spring, ALBuilt 1993 · S/N 2321 N2356ZOlson David C · Emmetsburg, IAS/N M-69 N23571Dlat Holdings LLC · Allen, TXBuilt 1977 · S/N TE-1120 N23573Rolrice Family Limited Partnership · Tulsa, OKBuilt 1977 · S/N TC-2107 N23575Registered aircraftBuilt 1965 · S/N 838 N23578Green Law Aviation Inc · Culpeper, VABuilt 1977 · S/N E-1185 N2357BSchneider Douglas P · Arlington, WAFirst renewal noticeBuilt 1993 · S/N 2273 N2357CBoyd Gary · Pearsall, TXBuilt 1993 · S/N 2312 N2357FBachand Kevin L · Leesburg, VABuilt 1964 · S/N 21058557 N2357LLords Assets LLC · Columbus, OHBuilt 1963 · S/N M-195 N2357NCreviston Steven Eric · Greensboro, NCBuilt 1998 · S/N E-3157

Back to AD 2007-04-19 R1