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.

N214CMKentucky Fly Boys Aviation LLC · Vine Grove, KYBuilt 1978 · S/N 372-78 N214DAFlight International Inc Trustee · Dover, DEBuilt 1999 · S/N 29-0181 N214DJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 0746 N214DKJohnson Matthew Alfred · Moorhead, MNS/N LIV-416 N214DMGrueninger Mark J · Benton, ILBuilt 1962 · S/N TC-285 N214DRMarsh David · Flower Mound, TXBuilt 1969 · S/N D-8997 N214DTBudicin Dominic A · Cedarpines Park, CABuilt 1979 · S/N 18266910 N214DXDixon Craig M · La Grande, ORBuilt 2013 · S/N 91863 N214EDWoods Johnny I · Hendersonville, TNBuilt 1980 · S/N 44-8195007 N214EPShumway Edwin · Tekonsha, MIBuilt 1956 · S/N 32485 N214ERLima-001 LLC · Muscatine, IAS/N 17263480 N214ESIsaacs Mark S · Terre Haute, INBuilt 1961 · S/N 18253673 N214FAGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281214 N214GGilpin Sean F · Madison, ALBuilt 1976 · S/N 21061237 N214GCCloud Robert Trustee · Kerrville, TXBuilt 2024 · S/N 18283286 N214GPPietsch Warren A · Minot, NDBuilt 1994 · S/N Z1A-0016 N214GSStephens Mark · Cullman, ALBuilt 1972 · S/N 28-7205138 N214GTAcba Inc Trustee · Wilmington, DEBuilt 2003 · S/N 2214 N214GZAerospring Leasing LLC · Wasilla, AKBuilt 2005 · S/N 172S9862 N214HPKilleen Sean B · Allentown, PABuilt 1980 · S/N 18267732 N214HRSchaetzel Paul · New Meadows, IDBuilt 2025 · S/N 345 N214JADer Aviation LLC · Dover, TNS/N 3122 N214JC214 Mooney LLC · Boca Raton, FLBuilt 1978 · S/N 24-0706 N214JDMilngavie LLC · Plano, TXBuilt 2006 · S/N 20416 N214JNFox-1 Drafting & Design Inc · Eagan, MNBuilt 1966 · S/N 30-1130 N214JPTop Flight Leasing LLC · Frankfort, ILBuilt 1994 · S/N 3213083 N214JSChavez Frederick J · Temecula, CABuilt 1997 · S/N 29-0128 N214KPBnb Aviation LLC · Chesterfield, MOBuilt 1999 · S/N TH-1894 N214LE3 Weens LLC · Hoschton, GABuilt 2004 · S/N 18281416 N214LHRocky Mountain Flight Consultants LLC · Boulder, COBuilt 2005 · S/N 494-2005 N214LMHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 44-7995053 N214LPKrasa Paul W · Yorktown, VAFirst renewal noticeBuilt 1999 · S/N 214KR N214MKoo C Carlos · Atherton, CABuilt 1985 · S/N P210-00863 N214MCCampbell Christian · Senoia, GAS/N D-6772 N214MHShadow Ventures LLC · Chesapeake, VAS/N T20608214 N214MKMargheritis Alex F Trustee · Saugus, CABuilt 2007 · S/N 81855 N214MMDunlap Lloyd A · Brighton, MIBuilt 1998 · S/N 335A-320-95 N214NMid Atlantic Air Museum · Reading, PABuilt 1955 · S/N 1-058 N214NYCabco Enterprises LLC · Springdale, ARS/N 899 N214PDN214pd LLC · Manakin Sabot, VABuilt 2008 · S/N 40.1018 N214PJCabral Diogo Da Silva · New York, NYBuilt 1978 · S/N 18266080 N214PTNewkirk Peter C · Ellison Bay, WIBuilt 1990 · S/N 2039 N214QHassenger Management Strategies Inc · San Antonio, TXBuilt 1965 · S/N D-7932 N214RLlano Charles · Lakeland, FLBuilt 1977 · S/N 32R7780522 N214RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 28-7690440 N214RBS And S 1165 Investments LLC · Wimberley, TXBuilt 1992 · S/N 2114 N214RCWhitcomb David · Morrisville, VTS/N D-7453 N214RDAardvark Aircraft LLC · Kalamazoo, MIBuilt 1964 · S/N 18255546 N214RJJones Larry V · Ocala, FLBuilt 1999 · S/N E3263 N214RRReiff Robert P · Fort Atkinson, WIBuilt 2008 · S/N 2646

Back to AD 2007-04-19 R1