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.

N150ABPurple Sage Aero LLC · Leonardtown, MDBuilt 1994 · S/N 04940068 N150AHRegistration Pending · Upland, CARegistration pendingBuilt 1993 · S/N 03930058 N150AKCamp Ted A · Williamson, GAS/N 04940071 N150ANBachman Aviation LLC · Independence, IABuilt 1995 · S/N 04940074 N150AQQualitair LLC Trustee · MichelstadtS/N 04940067 N150ATRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1994 · S/N 04940069 N150AYLegacy Aviation Foundation Inc · Staten Island, NYBuilt 1995 · S/N 04940073 N150AZPython Financial LLC · Kalispell, MTS/N CH400 N150BRegistered aircraftRegistration pendingBuilt 2002 · S/N 1199 N150BJDakota Air LLC · Delray Beach, FLBuilt 1983 · S/N 28-8311013 N150BKTribec Inc · Medina, OHBuilt 1969 · S/N 15070857 N150CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283268 N150CFDesutter S Bryan · Manito, ILBuilt 1980 · S/N 340A1215 N150CJMorrell John I · Seymour, TNBuilt 1994 · S/N 04940064 N150CPNelson Chris L · Yankton, SDBuilt 2018 · S/N 40919 N150CWCleveland William L · Lander, WYS/N 18-4329 N150DHHollenbaugh Roger Dean · Jamestown, COBuilt 1987 · S/N 240 N150DRVan Den Heuvel Michael E · Middleton, WIBuilt 1990 · S/N CE-1473 N150EPGedney William · Lake George, NYBuilt 1959 · S/N 18-7087 N150FSCustom Air International LLC · Homestead, FLBuilt 1975 · S/N 17265554 N150GHOtto Gregory A · Plano, TXBuilt 1997 · S/N DM0150 N150HCJones Luis · Las Vegas, NVS/N A1500725 N150HPGrimes Brian T · Kingman, AZS/N 001 N150JPSale Reported · King Salmon, AKSale reportedBuilt 2010 · S/N 001 N150KSSommers Stuart S · Newberg, ORBuilt 1951 · S/N 20-678 N150LELeading Edge Flight Academy LLC · Bend, ORBuilt 2000 · S/N 3150 N150LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842193 N150LMBrake Michael S Trustee · Granbury, TXBuilt 2007 · S/N 72529 N150MFRevolution Robotics Inc · Corvallis, ORBuilt 2001 · S/N 0015 N150MMAdams Jon S · Whitmore Lake, MIBuilt 1984 · S/N M-1-1115 N150NDClear Skies Avionics Inc · Clearwater, FLS/N 1186 N150NHPalmer Ronald Everett Trustee · Hopkinton, NHBuilt 1983 · S/N 18-8309012 N150PNational Test Pilot School · Mojave, CABuilt 2012 · S/N 18282357 N150PFParagon Flight Training Co · Fort Myers, FLBuilt 2022 · S/N 4496545 N150PPBurghduff Aviation LLC · Ludlow, SDS/N 25-23 N150PTAlchin Aviation LLC · Durand, MIBuilt 2005 · S/N 40.468 N150RVHolleman Charles F · West Lafayette, INBuilt 1987 · S/N 959 N150SCAnderson Thomas R · Seattle, WABuilt 1973 · S/N U20601958 N150SDLauff Samuel Jr · Ocala, FLBuilt 1998 · S/N 105 N150SPSale Reported · Colorado Springs, COSale reportedBuilt 2023 · S/N CX1900A-0001 N150STMiles Donald C · Columbia, MOBuilt 1977 · S/N 2996 N150SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11565 N150TBStevann Farms Ltd · De Witt, IABuilt 1959 · S/N 18-4303 N150TESummit Air LLC · San Diego, CABuilt 2009 · S/N 172S10996 N150TH150th Aero Flying Club · Morristown, NJBuilt 2003 · S/N 172S9453 N150UUKoshar Steven R · Coloma, MIBuilt 1961 · S/N D-6630 N150XTRice John D · Maddock, NDBuilt 2007 · S/N 1746 N15100Brothers Aviation Va LLC · Manassas, VABuilt 1972 · S/N 28-7225588 N15101Blackwater Air LLC · Pace, FLBuilt 1972 · S/N 28-7305020 N15104Mil2atp Inc · Pikeville, NCBuilt 1972 · S/N 28-7225590

Back to AD 2007-04-19 R1