Registered aircraft · 108,421

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.

N104MNCarpenter Jon Jay · Granada Hills, CABuilt 1997 · S/N 2777 N104MXFrancis Scott P · Montclair, VABuilt 2011 · S/N 11 N104NRainey Norman W · Surprise, AZBuilt 2007 · S/N 40348 N104NPDv Aviation Inc · Brainerd, MNBuilt 1975 · S/N 17265021 N104NRMiller Dale D · Eagle River, AKBuilt 1966 · S/N 18051693 N104PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 182-63801 N104PBMountain Flight LLC · Missoula, MTBuilt 1974 · S/N 20-0035 N104PDBaumann James R · Muskogee, OKBuilt 1973 · S/N 17261428 N104PKKreuter Paul E · Goshen, INBuilt 1974 · S/N 639 N104PMPats Offroad Inc · Mitchell, SDS/N 18258085 N104PTMacomber Donald C · Santa Ynez, CABuilt 1993 · S/N 2 N104RCChan Ronald G · Anchorage, AKBuilt 1966 · S/N 1851098 N104RGWeiss Elliott · Fresno, TXS/N 004 N104RVMetz Thomas · Northwood, NDBuilt 1985 · S/N 104A N104SJLockard John D · Oceanside, CABuilt 2001 · S/N 81278 N104SPJanaitis Aviation LLC · Middletown, DEBuilt 1973 · S/N 18261667 N104TBMclear Robert C · Rock Hill, SCBuilt 1973 · S/N 28-7415010 N104TEN104te LLC · Tucumcari, NMBuilt 2011 · S/N 13093 N104TMRegistration Pending · Lenoir, NCRegistration pendingBuilt 1992 · S/N 2635 N104TRAuburn Sheet Metal Inc · Enumclaw, WABuilt 1976 · S/N 18503212 N104TTTucker Thaddeus D · Wilder, IDBuilt 2003 · S/N 60531 N104UReed Russell M · White Salmon, WABuilt 2020 · S/N 5400 N104USHartenstine Michael C · Lancaster, CABuilt 1987 · S/N 7-0494 N104VADulles Aviation Inc · Bristow, VABuilt 2001 · S/N 2842115 N104WDHill Keith D · Kirby, ORBuilt 1979 · S/N P21000366 N104WWJarosak Peter J · Valparaiso, INBuilt 1981 · S/N E-1889 N104XLeider Robert G · Washoe Valley, NVBuilt 1970 · S/N 624 N104XPRv X Aviation LLC · Draper, UTBuilt 2006 · S/N 40111 N104ZURuttler James J · Bremerton, WABuilt 2015 · S/N 41103 N1050FBuchan John F · Port Ludlow, WABuilt 1975 · S/N 18502707 N1050RWatrous Scott A · Warrenton, VABuilt 1998 · S/N 21044C N1050TThrash Scott · Hesston, KSBuilt 1976 · S/N E-881 N1050VState Of Wisconsin · Madison, WIBuilt 1968 · S/N 18051966 N1051EHartman William · Imperial, MOBuilt 1977 · S/N 608-77 N1051SWhitfield David Michael · Cleveland, GABuilt 1998 · S/N 21039C N1051TOwens Randall C · Houston, TXBuilt 1998 · S/N 14092C N1051VSackett Ryan W · Anchorage, AKBuilt 1974 · S/N U20602421 N1051WAir Services International Leasing LLC · Fort Lauderdale, FLS/N 21035C N1051XNormand Glendon · Marksville, LABuilt 1975 · S/N 28-7525268 N1051ZDranttel Timothy John · Fuquay Varina, NCBuilt 1998 · S/N 25021C N1052FGlb Farms Inc · Pasco, WABuilt 1975 · S/N 18502709 N1052MFendt Alan D Trustee · Dexter, MIBuilt 1975 · S/N 18264216 N1052QNighthawk Air Systems Inc · Miami, FLS/N 310H0052 N1052TSale Reported · Crystal, MNSale reportedBuilt 1998 · S/N 20054C N1052UHuizinga Reinder C · Marietta, GAS/N 28007C N1053BLoveland Inc · Vance, MSBuilt 2005 · S/N 18281569 N1053HKoehn Danny · Montezuma, KSBuilt 1976 · S/N 28-7715304 N1053LKutzleb Michael K · Fernandina Beach, FLBuilt 2000 · S/N 29-0261 N1053THenderson State University · Arkadelphia, ARBuilt 1998 · S/N 21054C N1053XChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 172S9809

Back to AD 2007-04-19 R1