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.

N173PFRegistered aircraftBuilt 1997 · S/N 946 N173PKTrc-4k Investments LLC · Southlake, TXBuilt 1968 · S/N 17257364 N173PWSunspot Meadow LLC · Cloudcroft, NMBuilt 2004 · S/N 1362-2004 N173QLively Scott Jacob Charles · Greenbrier, ARBuilt 1964 · S/N D-7350 N173RGBuchert Christine W · SchweinfurtBuilt 1980 · S/N 172RG0218 N173SDMountain Aerobatics LLC · Chesterfield, MOBuilt 2011 · S/N 1108-2011 N173SNWilliams Hoffman Alexander M · Downers Grove, ILBuilt 1967 · S/N 32-912 N173TAughenbaugh Timothy A · Iroquois, SDS/N D-8259 N173VALegner Leasing LLC · Las Vegas, NVBuilt 1971 · S/N 172-60090 N173VRDauria William · Anna, TXBuilt 1971 · S/N 18260781 N173YAHoekman Kenneth J · Sherwood, ARBuilt 1980 · S/N 17274191 N17409Cirrus Aviation Inc · Sarasota, FLBuilt 2008 · S/N 172S10660 N1740CAmerican Aviation Inc · Brooksville, FLBuilt 2007 · S/N 172S10610 N1740GOelrich Matthew Alan · Concord, CABuilt 1962 · S/N CD-490 N1740TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12087 N1740WCarlsbad Raceway Corp · Hemet, CABuilt 1972 · S/N CD-1302 N1741CWitt William A · Ennis, MTBuilt 1953 · S/N 30441 N1741JReynolds David Hays J · Ariton, ALS/N 28-24157 N1741PWright Russell W · Ocala, FLBuilt 1954 · S/N 22-2531 N1741SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12288 N1742ECole-Tac LLC · Rapid City, SDBuilt 1978 · S/N 310R1558 N1742GLoftus Kevin · Pasadena, CABuilt 1962 · S/N CD-467 N1742SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12289 N1742VGalion Air Inc · Galion, OHBuilt 1974 · S/N 17263735 N1742XR&C Aviation Partners LLC · Tucson, AZBuilt 1975 · S/N 21060763 N1743GYoung Harrison · Phoenix, AZBuilt 1962 · S/N TC-278 N1743JRomualdi Giovanni · Torrance, CABuilt 1968 · S/N 28-24159 N1743LAir Inter LLC · Pittsburgh, PABuilt 2008 · S/N 172S10665 N1743RChronicle Aerospace Inc · Wilmington, DEBuilt 1974 · S/N 18502463 N1743SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12290 N1743VRegistered aircraftBuilt 1974 · S/N 17263736 N1743WThomas John J · Marana, AZBuilt 1972 · S/N D-9404 N1744GWelsh Ayden · Dayton, OHBuilt 1962 · S/N D-6953 N1744XDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21060765 N1745RFiske James K · North Andover, MAFirst renewal noticeBuilt 1974 · S/N 18502465 N1745SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12291 N1745TStoffer Aviation LLC · Marion, INBuilt 1970 · S/N 28-7125063 N1745WThoroughscape Inc · Wellington, FLBuilt 1972 · S/N CE-409 N1746CGreen Gary Dale · Mccarthy, AKBuilt 1953 · S/N 30446 N1746GFrasier Samuel · Gainesville, FLBuilt 1962 · S/N D-6952 N1746H1746h LLC · La Mirada, CAS/N 28R-7737011 N1746RSky West Aviation Inc Trustee · Albuquerque, NMS/N R18200543 N1746THessing Dale C · Eagle, IDBuilt 1970 · S/N 28-7125064 N1747BDgpiper · Sheridan, WYBuilt 1980 · S/N 20700666 N1747CConatser Patrick M · Homeland, CABuilt 1953 · S/N 30447 N1747GPalmenteri Louis J · Rhome, TXBuilt 1962 · S/N CD-492 N1747JCromwell James A · Little Rock, ARBuilt 1968 · S/N 28-24165 N1747LCoco Aircraft Inc · Merritt Island, FLBuilt 2007 · S/N 17281489 N1747MMcmillan James D · Abilene, TXBuilt 1975 · S/N 18264425 N1747RFite Rodney Edward · San Lorenzo, CABuilt 1978 · S/N R18200544

Back to AD 2007-04-19 R1