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.

N121BLOlson Brian D · Las Vegas, NVBuilt 1982 · S/N TJ-413 N121BPFord Kevin L · Peachtree City, GABuilt 1968 · S/N 015 N121BRSmith Tad E · Colorado Springs, COS/N 1697 N121BWLester Jon M · Lancaster, OHBuilt 1979 · S/N TC-2256 N121CBClark Andrew R · Woodside, CABuilt 1976 · S/N 340A0087 N121CEAdvanced Flight Instruction LLC · Greenwood, DEBuilt 1974 · S/N 21060503 N121CJCharlie Juliet Aerospace LLC · Naugatuck, CTBuilt 2005 · S/N 40.466 N121CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13480 N121CRMaxson Lee V · Mesa, AZS/N 418 N121CWAerostar Training Services LLC · Kissimmee, FLBuilt 2001 · S/N 172S8975 N121DSongbird Aviation LLC · Larkspur, CABuilt 1984 · S/N CE-1033 N121DBTexins Flying Club · Mckinney, TXBuilt 1972 · S/N 28R-7335024 N121DDRowlands Owen D · Pueblo West, COBuilt 2013 · S/N 12136 N121DRJohnson And Son Enterprises · Dunn, NCBuilt 1974 · S/N 310Q1046 N121DSGarvison Paul L · Hillsville, VABuilt 1995 · S/N 22373 N121DWFlight World Inc · San Juan, PRBuilt 1972 · S/N 312 N121EConger Martin D · Pasco, WABuilt 1963 · S/N 173 N121ECN121ecfllyers LLC · South Jordan, UTBuilt 1967 · S/N 17700036 N121EDLarry K Brown · Round Rock, TXBuilt 1979 · S/N 80-30969 N121EESheldon Air Service LLC · Anchorage, AKBuilt 1979 · S/N 18503765 N121EMRegistration Pending · Austin, TXRegistration pendingBuilt 1966 · S/N 18257784 N121ERFreedom Aviation LLC · Dover, DES/N 1510 N121ESWell Bilt Industries USA LLC · Ocala, FLBuilt 1971 · S/N 28-7125383 N121FHamilton Wayne J · Mesa, AZBuilt 1956 · S/N 32353 N121FTBowman William K · Raleigh, NCBuilt 1982 · S/N 28-8216191 N121GAWood David J · Lincolnshire, ILBuilt 2005 · S/N 1443 N121GBAviation Academy LLC · Wichita, KSBuilt 1968 · S/N 17257308 N121GJ424 Ventures LLC · Saint Petersburg, FLBuilt 1976 · S/N TJ-62 N121GKBook Thomas D · Loveland, COBuilt 2003 · S/N 2767 N121GPTaft Diversified LLC · Springfield, ILBuilt 1985 · S/N 46-8508086 N121GRSimmons Scott J · Palm Springs, CABuilt 1978 · S/N 2159 N121HCUsaircraft Inc · Newark, DEBuilt 2002 · S/N 0277 N121HEJarrett Air LLC · Ashland City, TNBuilt 1979 · S/N 32-7940127 N121HHTimm Robert S · Minneapolis, MNBuilt 1992 · S/N 1209 N121HSCharles Dan H · Des Allemands, LAS/N 121 N121HTSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 0794 N121JAAlbers Edward J Jr · Oviedo, FLBuilt 1991 · S/N 121 N121JCNewsom William A · Cheraw, SCBuilt 2000 · S/N F0010 N121JLPlane Fun Inc Tr Trustee · Snellville, GABuilt 1993 · S/N ODOM 0001 N121JMBullet Aviation LLC · Missoula, MTBuilt 2025 · S/N 18283317 N121JRKlotz Geoffrey B · Moor Park, CABuilt 1977 · S/N 21061726 N121JZZack Jay T · Cloquet, MNBuilt 2002 · S/N 0121 N121KAAir Ally Asset Management LLC · Chisago City, MNS/N 17263836 N121KSCa-C180j LLC · Addison, TXBuilt 1976 · S/N 18052683 N121LATgl Inc · Wilmington, DEBuilt 1973 · S/N 310Q0973 N121LCJolisea Wings LLC · Palm Bay, FLBuilt 2003 · S/N 21161 N121LGPayton Kathleen · Grand View, IDBuilt 1964 · S/N TC-777 N121LLWild Blue Air LLC · Homer, AKBuilt 1977 · S/N U20603756 N121LMGolden Age N121lm LLC · Des Moines, IABuilt 2022 · S/N 2881529 N121LTDream 10 LLC · Dunnellon, FLBuilt 2024 · S/N 42367

Back to AD 2007-04-19 R1