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.

N1486TSpivey Darwyn D · Guntersville, ALBuilt 1972 · S/N 28-7225533 N1486UMoss Motor Company Inc · South Pittsburg, TNBuilt 1976 · S/N 17267153 N1486XMidwest Investment Corp · Griffith, INS/N 28R-7535291 N14872Blumenthal James R · Kingman, AZBuilt 1973 · S/N U20602144 N1487CDuley Brian · Lago Vista, TXBuilt 2003 · S/N 0571 N1487PSingh Harsimran · Las Vegas, NVS/N 23-556 N1487SSkovira Michael D · Scottdale, PABuilt 1976 · S/N 18265034 N1487TFalcon Flying Club LLC · Fayetteville, GABuilt 1972 · S/N 28-7205307 N1487UNew Richard A · Deming, WABuilt 1976 · S/N 17267154 N1487VFirst Flight Corporation · San Diego, CABuilt 1974 · S/N 17263621 N1488Booth Mac E · Independence, ORS/N 303 N1488CChristiansen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 172S12896 N1488UShine Donald J · Waterford, WIBuilt 1976 · S/N 17267155 N1488VPerks Brian G · Otis Orchards, WAS/N 17263622 N1489EWings Over Water Inc · Minneapolis, MNBuilt 1978 · S/N 17271019 N1489LBusiness Mens Flying Club Inc · Naperville, ILBuilt 2007 · S/N 18281901 N1489MBrinker Corp Inc · Glen Elder, KSBuilt 1975 · S/N 18264350 N1489SBender Roger J · Overgaard, AZBuilt 1976 · S/N 18265036 N1489TLion Aviation LLC · Kansas City, MOBuilt 1972 · S/N 32-7200042 N1489UAustin Aeroflight Inc · Austin, MNBuilt 1976 · S/N 17267156 N148AParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020203 N148ACMach 1 Aircraft LLC · Malibu, CABuilt 1993 · S/N 717-93 N148AMEightalphamike LLC · Kissimmee, FLBuilt 2001 · S/N 2148 N148BCWalker Dean M · Fort Collins, COBuilt 2008 · S/N 507-2008 N148CAAfrican Parks Aviation Inc Trustee · Cheyenne, WYBuilt 2005 · S/N 2293 N148CCDream Aero Holdings LLC · Clackamas, ORBuilt 2003 · S/N 9955CC N148DHLeclerc Robert L · Olympia, WABuilt 1994 · S/N 3082 N148DPHenke Kristen C · Bettendorf, IAS/N 11015C N148FRamsey William · Eagan, MNBuilt 2000 · S/N 6035 N148FCDepartment Of Agriculture & Consumer Scvs · Tallahassee, FLBuilt 2022 · S/N 2881520 N148GMorrill William I · Kerrville, TXBuilt 1979 · S/N 18267097 N148JBBell Jason W · Flower Mound, TXBuilt 1979 · S/N 18266827 N148KMRstl LLC · Minster, OHS/N 28-7990342 N148LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842191 N148LMMoore Shelby L · Mount Pleasant, NCBuilt 2005 · S/N 5494 N148MHSmith Timothy Landon · Jonesville, NCBuilt 2017 · S/N 22570 N148PCSuperd LLC · Everett, WABuilt 2005 · S/N 996-2005 N148PRJaspar Dorsey E · Bakersfield, CABuilt 1967 · S/N D-8580 N148PSAsplundh Wayne B · Philadelphia, PABuilt 2001 · S/N 6048 N148RHPlum Aggregate LLC · Porter, TXBuilt 2017 · S/N 14048 N148RRDunbar Richard · El Dorado Hills, CABuilt 1978 · S/N AA5B-1008 N148SBGriner Warren D · Pinson, ALBuilt 1966 · S/N 30-1148 N148SMSarasota Westwind Flyers Inc · Sarasota, FLS/N 18280040 N148SWHess Daniel A · Cookeville, TNBuilt 2004 · S/N 0987 N148TABusiness Revenue Corp · Newton, IABuilt 1998 · S/N 6014 N148TSLazy Dog Aviation LLC · North Myrtle Beach, SCBuilt 2005 · S/N 1451 N148TTBoard Of Trustees Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496428 N148TXRegistration Pending · Austin, TXRegistration pendingBuilt 1979 · S/N 18267500 N148UUpmeyer Matthew D · Richland, WABuilt 1967 · S/N D-8437 N14908Reiter Scott D · Leesburg, VABuilt 1974 · S/N 74-30662

Back to AD 2007-04-19 R1