Registered aircraft · 108,428

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.

N1734XRight Wing Left Wing Flyers LLC · Cleveland, GABuilt 1975 · S/N 21060755 N1735ERsc Ventures LLC · Phoenix, AZBuilt 1978 · S/N 310R1555 N1735GFeldhaus Joseph H · Shelbyville, TNBuilt 1962 · S/N CD-489 N1735MG & M Aircraft Inc · Wheat Ridge, COBuilt 1975 · S/N 18264421 N1735XAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10648 N1736CThompson Frank L · Weiser, IDBuilt 1953 · S/N 30436 N1736PRegistered aircraftBuilt 1954 · S/N 22-2526 N1736TN1736t LLC · Lake Point, UTBuilt 1970 · S/N 28-7125052 N1736WAmbitious Aviation LLC · Newport News, VABuilt 1972 · S/N D-9403 N1737High Flight Academy LLC · Allison Park, PABuilt 1975 · S/N 17265682 N1737ARegistration Pending · Bulverde, TXRegistration pendingBuilt 1964 · S/N 28-1540 N1737BDiaz Juan B III · Portland, ORBuilt 1972 · S/N D-9405 N1737CBristol Brian P · Webster, MNBuilt 1953 · S/N 30437 N1737EKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1556 N1737GBraly John E · Surprise, AZBuilt 1962 · S/N D-6948 N1737LZdad Aviation LLC · Little Rock, ARBuilt 2007 · S/N 18282038 N1737MClinton Aviation Corp · Clinton, ARBuilt 1975 · S/N 18264423 N1737RMorales Richard · Palm Springs, CABuilt 1978 · S/N R18200541 N1737STms Aviation Inc · Wilmington, DEBuilt 2000 · S/N 18280763 N1737TN1737t LLC · West Palm Beach, FLBuilt 1970 · S/N 28-7125054 N1737VWatson Patrick D · Kenyon, MNBuilt 1974 · S/N 17263732 N1738ALyall Gregory S · Anchorage, AKS/N 18-1311 N1738CScc Aviation LLC · Caldwell, TXBuilt 2007 · S/N 18282040 N1738GSchneider Joel A · Cerrillos, NMBuilt 1962 · S/N D-6950 N1738JPiper 38j LLC · Buckeye, AZBuilt 1968 · S/N 28-24153 N1738SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12287 N1738TClinton 83 Aviation LLC · La Place, LAS/N 28-7125055 N17396Eckel Kenneth P Jr · Santa Fe, TXBuilt 1951 · S/N 22135 N1739COpp Daniel · Anchorage, AKBuilt 1953 · S/N 30439 N1739JSahli Theodore E · Costa Mesa, CABuilt 1968 · S/N 28-24154 N1739TWatkins Felton III · Meridian, MSBuilt 1970 · S/N 28-7125056 N173AWLongwing Company LLC · Plymouth, MNBuilt 2022 · S/N 172S12859 N173BADunlap Jolene · Peoria, ILBuilt 1979 · S/N 17272370 N173CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283269 N173DSanford Mark J · Ithaca, NYBuilt 1964 · S/N TC-825 N173DCSkyvibe Leasing LLC · Aurora, ORBuilt 2016 · S/N 172S11720 N173EFEliason James T · Prescott, AZBuilt 2002 · S/N 5298 N173EXHauck Brian A · Santa Rosa, CABuilt 2004 · S/N DMO-282 N173JPRochin Eric M · Malibu, CABuilt 2005 · S/N 40.486 N173KADaigle Lawrence J · Cohasset, MNBuilt 1972 · S/N 17260939 N173KHD & B Management LLC · Clayton, GABuilt 2004 · S/N 1191 N173KMLd Enterprises Llp · Roswell, GABuilt 1968 · S/N 17257781 N173KTCrawford Chris M · North Dinwiddie, VAS/N 40035 N173LLRegistration Pending · Barrigada, GURegistration pendingBuilt 1982 · S/N 17275633 N173MMitchell Jonathan L · Poteau, OKBuilt 1981 · S/N 32R-8113087 N173MAStellar Aviation LLC · Benton, KYBuilt 2003 · S/N 40.292 N173MCCiochetti Michael J Jr · Clayton, GABuilt 1968 · S/N 21058960 N173MEBox Aviation Inc · Montgomery, ALBuilt 2000 · S/N 172S8455 N173MMDuyck Mickey E · Soldotna, AKBuilt 2011 · S/N 70363 N173PBLee Bradford W · Austin, TXBuilt 2003 · S/N 172S9442

Back to AD 2007-04-19 R1