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.

N2331JTechnical Education Services Inc · Virginia Beach, VABuilt 1963 · S/N M-284 N2331MSmith Ctr Kite Club Inc · Smith Center, KSBuilt 1977 · S/N 28-7890247 N2331RSawicki Michael T · Midland, MIBuilt 1964 · S/N 18255431 N2331XHelistream Inc · Kalispell, MTBuilt 1992 · S/N 2145 N2331ZDovetail Aviation LLC · Saint George, UTBuilt 1962 · S/N M-41 N2332CBalgoyen James T · Charlotte, MIBuilt 1954 · S/N 30632 N2332EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271238 N2332JDon M Barron Contractor Inc · Farmerville, LABuilt 1999 · S/N E-3262 N2332TFinch Stanley F · San Marcos, TXBuilt 1978 · S/N AA5B0934 N2332YAlbi Aero LLC · Denver, COBuilt 1967 · S/N 17700132 N23333Leading Edge Aviation LLC · Lewiston, IDBuilt 1968 · S/N 15068880 N2333BN2333b LLC · Oklahoma City, OKBuilt 1997 · S/N TH-1833 N2333CAfs Inc · Grants Pass, ORBuilt 1978 · S/N R18200152 N2333GRegistration Pending · Belen, NMRegistration pendingS/N 51633 N2333HHolseberg Aviation LLC · Ridgeville, SCBuilt 1979 · S/N 18-7909171 N2333QLawarch LLC · Hollywood, FLBuilt 1963 · S/N M-399 N2333RSightler Marshal · Taylors, SCBuilt 1969 · S/N 28-5491 N2333TNottingham Jeffrey A · Locust Grove, GABuilt 1971 · S/N 28R-7135204 N2333VTytan Holdings LLC · Kalispell, MTBuilt 1998 · S/N E-3183 N2333XHjr Aviation LLC · Reno, NVBuilt 1965 · S/N 18256233 N2333YSkillman Flying Services LLC · Brookshire, TXS/N 17700133 N2334CTallahassee Flying Club Inc · Tallahassee, FLBuilt 1978 · S/N R18200153 N2334GHegna David E · Wall Township, NJBuilt 2005 · S/N 172S9994 N2334HFff Air LLC · Ashland, OHBuilt 1979 · S/N 18-7909172 N2334JThree Four Juliet LLC · Orange, CABuilt 2005 · S/N 172S9995 N2334KSixty Six Holdings LLC · King, NCS/N 2159 N2334LDupuy Christopher R · Pass Christian, MSBuilt 1963 · S/N M-165 N2334MSunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 28R-7837083 N2334QBledsoe Timothy Ronald Jr · Woodstock, GABuilt 1963 · S/N M-396 N2334TGogoplex LLC · Wilmington, DEBuilt 1971 · S/N 28-7125637 N2334WBlazek James T · Malta, ILBuilt 1997 · S/N E-3134 N2334XEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1992 · S/N 2149 N23353Weems Widener E · San Antonio, TXBuilt 1974 · S/N 17264085 N2335EMindy Limited LLC · Muscatine, IABuilt 1978 · S/N 17271240 N2335FGravitte Peter F · Napa, CAS/N 21058535 N2335GRegistered aircraftBuilt 1958 · S/N 51635 N2335JDank Noah S · Jacksonville, FLS/N M-291 N2335KBflyin LLC · Scottsdale, AZBuilt 1997 · S/N E-3135 N2335PGrosse Martin · Viola, WIBuilt 1955 · S/N 22-2746 N2335RPropellerhead Aviation LLC · Santa Cruz, CABuilt 1997 · S/N TH-1835 N2335UDolphin Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9997 N2336GLogue Elmer S · Derby, KSS/N 51636 N2336LBerry Kenneth W · Amarillo, TXBuilt 1963 · S/N M-167 N2336MHerd James L · Gardnerville, NVBuilt 1997 · S/N E-3136 N2336RPerera Nandana L · Logan, OHBuilt 1969 · S/N 28-5494 N2336TN2336t Airplane Partnership LLC · Wilmington, DEBuilt 1971 · S/N 28R-7135209 N2336VW Tech Consulting Inc · Wilmington, DEFirst renewal noticeBuilt 2007 · S/N 172S10536 N2337LAbitia Alberto · Phoenix, AZBuilt 1963 · S/N M-168 N2337QFleener Michael C · Livingston, TXS/N M-402 N2337TPate Jason L · Bedford, TXBuilt 1997 · S/N E-3137

Back to AD 2007-04-19 R1