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.

N136AFMorley John A · Tewksbury, MABuilt 1981 · S/N E1861 N136AMButler Aviation Llp · Smyrna, TNBuilt 1991 · S/N E2641 N136AVHarford Archer Owners Group LLC · Bel Air, MDBuilt 1984 · S/N 28-8590004 N136BSmith Richard M · Newton, MSBuilt 1973 · S/N E-390 N136BACoppotelli Robert C · Plano, TXBuilt 1960 · S/N CD-44 N136BEHeavy D Airways LLC · Fountain Hills, AZBuilt 1992 · S/N EA-541 N136CCShelk John Brian · Bend, ORBuilt 2002 · S/N 9953CC N136CDSnow Jason D · West Lafayette, INBuilt 1977 · S/N E-1162 N136CHHall Kenneth C · Kernersville, NCBuilt 2004 · S/N 449 N136CMTriple C Inc · Carlsbad, NMS/N EA-437 N136CPMaule Flight Inc · Moultrie, GABuilt 2002 · S/N 18071C N136CWCdh Properties LLC · Oklahoma City, OKBuilt 1984 · S/N E-2207 N136DBuckeye Ridge Farm LLC · Vidalia, GABuilt 1978 · S/N 14361 N136DCStreamline Aviation LLC · Battlefield, MOBuilt 1982 · S/N 136 N136DDMason Daniel Racing LLC · Porterville, CABuilt 1981 · S/N EA-212 N136DKReece Robert B · Halstead, KSBuilt 2003 · S/N 24654 N136DWSun Aircraft Management LLC · Ormond Beach, FLBuilt 2003 · S/N 4496168 N136EHHatfield Enterprises LLC · Shreveport, LABuilt 1979 · S/N E-1555 N136FSale Reported · Broomfield, COSale reportedBuilt 2001 · S/N 60300 N136FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290171 N136GBHarris Vincent A · Columbus, MSBuilt 1967 · S/N D-8557 N136GHRegistered aircraftBuilt 2001 · S/N E-3414 N136GRClear Skies Cdk LLC · Fort Myers, FLBuilt 1983 · S/N E2115 N136HBSoaring With Steve LLC · Papillion, NEBuilt 2013 · S/N E-3987 N136HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9711 N136HPHigh Performance Aircraft Inc · El Cajon, CABuilt 2001 · S/N E-3383 N136HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 21094C N136JRaichl John P · Astoria, ORBuilt 1962 · S/N 205-0136 N136JLRedline Aviation LLC · Madison, MSBuilt 2009 · S/N E-3891 N136JMGregory Warren D Jr · Aguila, AZBuilt 1963 · S/N 22-5557 N136JWThree Mayhoods LLC · Bonita Springs, FLBuilt 1979 · S/N E-1127 N136KWatkins Joe C · Highlands, NCBuilt 2000 · S/N E-3310 N136KCPrescribed Agriculture Services Inc · Bakersfield, CABuilt 1978 · S/N E-1373 N136LMLge Flying Club · Canton, GABuilt 1975 · S/N 17265041 N136MDMinch Jeffrey · Austin, TXS/N E-3424 N136MMMiller Carl A · Vero Beach, FLBuilt 1993 · S/N 21718 N136PFlying Daze · Batavia, OHS/N E-3029 N136PJPj Helicopters · Red Bluff, CABuilt 1978 · S/N E-1314 N136QRice James A · Holden, WVBuilt 1959 · S/N 52163 N136RCCaldwell Richard A · Indn Hbr Bch, FLBuilt 2000 · S/N 24187 N136RFAltitude Flight Solutions LLC · Glasgow, MTBuilt 1995 · S/N E-2940 N136RKAero-Springs LLC · Ocean Springs, MSBuilt 2015 · S/N E-4069 N136RLRegistered aircraftBuilt 1978 · S/N E1326 N136RRGlye David W · Prospect, KYBuilt 2007 · S/N E-3760 N136SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1993 · S/N 10164 N136SHLlano Capital LLC · Fredericksburg, TXBuilt 1994 · S/N E-2894 N136SKKottman Steven A · Anaheim, CABuilt 2014 · S/N E-4033 N136SMMartens Aerosports LLC · Garden City, NYBuilt 1998 · S/N 066 N136STScull Timber Co Inc · Tenaha, TXBuilt 1978 · S/N 18266476 N136TWilliams Jack K · Big Bear Lake, CABuilt 2018 · S/N 32-0005

Back to AD 2007-04-19 R1