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.

N10446Schell Brothers II LLC · Rehoboth Beach, DEBuilt 1973 · S/N 172-62515 N1044FNottorf Eric W · Keller, TXBuilt 1995 · S/N 20046C N1044JNagasaka Bruce J · Weiser, IDBuilt 1973 · S/N 44 N1044LFitch Mark · Anchorage, AKBuilt 1996 · S/N 25009C N1044NMaule Flight Inc · Moultrie, GABuilt 1996 · S/N 25006C N1044VTigers Air Inc · Fairfax Station, VABuilt 2003 · S/N 29-0317 N1044WAngier 66 LLC · Durham, NCBuilt 1973 · S/N D-9457 N1045Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020177 N10457Six Ten Ventures LLC · Cedar Hill, TXBuilt 2003 · S/N 20608194 N1045FOpc Consulting LLC · Hickory Corners, MIBuilt 2001 · S/N 29-0273 N1045JFenn Matthew A · Liberal, KSBuilt 1996 · S/N 004 N1045LBernard Robert J · Millbury, MABuilt 1974 · S/N 638 N1045QWolf Mark W · Long Lake, MNBuilt 1963 · S/N 310H0045 N1045RKersting Thomas J · Volga, SDBuilt 1998 · S/N 21042C N1045WButler Richard S · Poplar Grove, ILBuilt 1973 · S/N TC-1535 N1045XServaty Frank R · Canyon Lake, TXBuilt 2000 · S/N 29-0232 N1045YRovers Bradley S · Chazy, NYBuilt 2005 · S/N 18281571 N10469Airscout LLC · Valdosta, GABuilt 2004 · S/N 29-0336 N1046BOglesby Jonathan D · Okmulgee, OKBuilt 1958 · S/N 1273 N1046ERisk Indemnification Professionals LLC · Boston, MABuilt 1977 · S/N 296-77 N1046QAcharya Jay P · Powell Butte, ORS/N 310H0046 N1046VSusitna Air Service LLC · Anchorage, AKBuilt 1974 · S/N U20602418 N1046XFarnham Aviation Services LLC · Ames, IABuilt 1975 · S/N 28-7525266 N10470Leary Dan P · Girdwood, AKBuilt 1951 · S/N 18-895 N10475Lissow William M · New Port Richey, FLBuilt 1967 · S/N 67-18368 N1047FBondurant Jok · Talkeetna, AKS/N 18502704 N1047JFirst Flight Investments LLC · Bartow, FLBuilt 1973 · S/N 47 N1047LMcneill Philip · Reston, VABuilt 2003 · S/N 29-0320 N1047MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 2842286 N1047NMccormick William R · Louisville, KYBuilt 1998 · S/N 28005C N1047UStueve'S Certified Organic Dairy · Oakdale, CABuilt 1998 · S/N 23043C N1047VPoulter Thomas R · Chelsea, MIBuilt 1954 · S/N 18-3911 N1047W1047w LLC · Oakland, TNBuilt 1973 · S/N TC-1536 N1047YDonato Deleonardis · Paulden, AZBuilt 1997 · S/N 25016C N10480Piper 66 LLC · Kirksville, MOBuilt 1966 · S/N 32-279 N10481Marshburn Leroy D III · Kernersville, NCBuilt 1998 · S/N 21036C N1048AUnderdahl Kirby L · Hamilton, MTBuilt 1951 · S/N 18-626 N1048EPaul John R · Boise, IDBuilt 1977 · S/N 343-77 N1048FWard Anthony · Paige, TXBuilt 1997 · S/N 21013C N1048LSparrow Thomas E · Hawley, MNBuilt 1974 · S/N 641 N1048QTaf Aerial Services LLC · Corpus Christi, TXBuilt 1997 · S/N 21034C N1048TTrotter Thomas J · Bremerton, WABuilt 1997 · S/N 23037C N1048XRaven Aircraft LLC · Waynesville, OHS/N 25043C N1049JLoxley Jason C · Virginia, ILBuilt 1972 · S/N 49 N1049PLamal Thomas K · Fairbanks, AKBuilt 1957 · S/N 18-7816 N104AHickman John E Jr · Coronado, CABuilt 1947 · S/N C-104-212 N104AAMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881573 N104ABPeterson Kevin D · Peoria, AZBuilt 1998 · S/N 18280280 N104ACRoss Stephen D · Greenfield, OHBuilt 1993 · S/N 363-93 N104AFNance David B · Quinton, VABuilt 1967 · S/N 17700238

Back to AD 2007-04-19 R1