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.

N1547MArtman John W · Lynnwood, WABuilt 1975 · S/N 18264371 N1547XKoch Steven T II · Brownsburg, INBuilt 1975 · S/N 28R-7535321 N1547ZDowning Darren J · Knoxville, TNBuilt 1961 · S/N CD-423 N15483Tnj First Class Flying Properties LLC DBA · Dallas, TXBuilt 1972 · S/N 28-7305082 N15484Thompson Mark L · Kirksville, MOBuilt 1972 · S/N 28-7325076 N15489Black Knights Transportation Services LLC · Garden Grove, CABuilt 1972 · S/N 28-7325079 N1548CRoy Flying Service LLC · Lettsworth, LABuilt 1953 · S/N 30248 N1548FBovine Aerial LLC · Amarillo, TXBuilt 1989 · S/N E-2489 N1548GG T Aviators LLC · Naples, FLBuilt 1989 · S/N E-2479 N1548PUS Aviation Training Solutions · Titusville, FLBuilt 2005 · S/N 0199 N1548RJohnson Jimmy G A III · Edmond, OKBuilt 1975 · S/N AA5B-0048 N1548TWd21 Aviation Holdings LLC · Albany, NYBuilt 1989 · S/N E-2482 N1548VFabtex Solutions Inc · Morganton, NCBuilt 1989 · S/N E-2477 N1548WCrabb Joseph M · Tempe, AZBuilt 1972 · S/N D-9344 N15493Midwest Flying Service Inc · Elgin, NEBuilt 1972 · S/N 28-7310050 N15499Lankford Toby C · Canadian, TXBuilt 1972 · S/N 28-7325080 N1549CDavidson Ron · Newfolden, MNBuilt 1953 · S/N 30249 N1549KTallevast LLC · Sarasota, FLBuilt 1988 · S/N E-2460 N1549NCampbell Catherine D · Dana Point, CAS/N E-2474 N1549TPalmer Jonathan L · The Woodlands, TXBuilt 1973 · S/N 310Q0755 N154ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010049 N154AVDaviation Inc · Willoughby, OHBuilt 1985 · S/N 28-8616018 N154BCTen Knot Tailwind LLC · Mesa, AZBuilt 1969 · S/N 21059157 N154CPCivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283319 N154CSGlass Cockpit Aviation LLC · N Massapequa, NYBuilt 2004 · S/N 0915 N154DSIn Flight Aircraft LLC · Howell, MIBuilt 2004 · S/N 40.461 N154EFAdams Donald C · Garner, NCBuilt 1968 · S/N 21059089 N154ERN154er LLC · Kissimmee, FLBuilt 1989 · S/N 2841182 N154FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2006 · S/N 18281785 N154FTMiloud Chadd K · Fort Worth, TXS/N 28-8216194 N154GRRussell Gregory · Stevensville, MDBuilt 1976 · S/N AA5A-0213 N154JNMatos Holdings Corp · Weston, FLBuilt 2001 · S/N 0126 N154LSSindhu Azhar · Humble, TXBuilt 2004 · S/N 1240 N154MNapier Aircraft Inc · Wilmington, DEBuilt 1981 · S/N E-1930 N154MASportsman Airpark Inc · Newberg, ORBuilt 2001 · S/N 260008 N154MDSwenson John E · Belgrade, MTS/N 154MD N154PAParagon Airplane Leasing Co · Fort Myers, FLBuilt 2020 · S/N 28020012 N154PKPerry Patrick J · Dallas, PABuilt 2001 · S/N 154 N154QBrandon Sidney Jordan III · Dundas, VABuilt 1964 · S/N TC-798 N154RAFulwiler Air LLC · Green Bay, WIBuilt 2005 · S/N 1391-2005 N154RVLavalley Thomas L · Colorado Springs, COBuilt 2015 · S/N 004 N154SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4151 N154TKornchuk Kurt C · Wasilla, AKS/N 18-2268 N154WKObx Airplanes LLC · Manteo, NCBuilt 1974 · S/N 451-74 N154ZJAttitude Aerobatics LLC · Wilmington, DEBuilt 2018 · S/N 3312 N154ZPAirsign Airships America LLC · Williston, FLBuilt 1999 · S/N 104 N15504N15504 LLC · Eatontown, NJBuilt 1972 · S/N 28-7325082 N1550CGlidden Timothy J · Millinocket, MEBuilt 1953 · S/N 30250 N1550DAlexander Air Consulting LLC · Lees Summit, MOBuilt 1989 · S/N CE-1317 N1550EWilts George W · Streator, ILBuilt 1978 · S/N 17271043

Back to AD 2007-04-19 R1