Registered aircraft · 816

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:88-26-01-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-26-01-R2') 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:88-26-01-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-26-01-R2')
  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:88-26-01-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-26-01-R2')
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.

N515UDTumbleweed Leasing Company Inc · Salt Lake City, UTS/N 3515 N519GPEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 2039 N520KTTroendle Adam J · Dexter, MNBuilt 2026 · S/N 4931 N521RLCherry Creek School District No 5 · Greenwood Village, COS/N 0216 N522AGHampton Roads Charter Service · Chesapeake, VABuilt 2006 · S/N 4037 N522JMsr22 LLC · Perkinston, MSBuilt 1997 · S/N 2691 N522KPNelson Christopher C · Crown Point, INBuilt 1994 · S/N 2457 N522SBTrinity Aviation LLC · Georgetown, TXBuilt 2021 · S/N 4845 N523KCGarrett Ag Equipment Ltd · Premont, TXS/N 3944 N524AHAtlantic Aviation International Inc · Lewes, DES/N 1378 N525VDStefenelli Aviation N Tr Inc Trustee · AtterseeBuilt 1992 · S/N 2251 N527RHArrow Helicopter LLC · Canton, MIS/N 1527 N5309TWorld Trade Enterprises LLC · Lucas, TXS/N 4929 N531FWWorld Trade Enterprises LLC · Lucas, TXS/N 4930 N540FCRaschio Ernesto · Doral, FLS/N 3858 N542GAtlantic Helicopters International Inc · Lewes, DENon-citizen corporation, flight hours not reportedBuilt 1994 · S/N 2459M N54BAEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1888 N54BPDefibaugh Fred M · Chino Valley, AZS/N 1165M N54FDDefibaugh Fred M · Chino Valley, AZBuilt 2005 · S/N 3823 N552LELeading Edge Flight Academy LLC · Bend, ORBuilt 2003 · S/N 3502 N554GLConcho Aviation LLC · Sterling City, TXBuilt 2002 · S/N 3399 N555UHAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3550 N555UPAtlantic Coast Helicopter Ltd · Ronkonkoma, NYBuilt 1998 · S/N 2792 N556SHNovember Alpha LLC · Dover, DEBuilt 2004 · S/N 3581 N558SHAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 2004 · S/N 3582 N559DDRobinson Helicopter Co Inc · Torrance, CAS/N 3299 N5643Fingerlakes Wing And Rotor LLC · Seneca Falls, NYS/N 4033 N56FDDefibaugh Fred M · Chino Alley, AZS/N 3535 N574RJJets To Helis LLC DBA · Chandler, AZBuilt 2023 · S/N 4888 N575TAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 2007 · S/N 4164 N577ZZRubey Arthur C · San Antonio, TXBuilt 2024 · S/N 4903 N588LESmith Jason E · Calliham, TXBuilt 2004 · S/N 3588 N597LELeading Edge Aviation Inc · Bend, ORBuilt 1986 · S/N 597 N600TLLbaviation LLC · Wheatland, WYS/N 1148 N601LANicely Juan · Mount Vernon, KYS/N 1473 N603HHHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1991 · S/N 1706 N605HAEmerald City Aircraft Leasing Inc · Port Orchard, WAS/N 0439 N611CVRegistered aircraftBuilt 1999 · S/N 2988 N6153FEmployment Services Inc T/A · Virginia Beach, VAS/N 0091 N617DRRadford David M · Glen Cove, NYBuilt 2018 · S/N 4791 N61JHHobbs Christopher J · Pinson, ALBuilt 1991 · S/N 1829 N622MPSpitzer Helicopter LLC · Woodland Hills, CABuilt 2006 · S/N 4016 N622NL1st American Aviation Inc · North Miami, FLS/N 0386 N622SAParker Helicopter LLC · Watsonville, CABuilt 2005 · S/N 3912 N6262XGriggs Levi · Morganfield, KYBuilt 1981 · S/N 0226 N6291TEmerald City Aircraft & Leasing Inc · Port Orchard, WABuilt 1994 · S/N 2410M N62JFAirtrade Aviation Corp · Lewes, DENon-citizen corporation, flight hours not reportedS/N 3922 N63990Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1987 · S/N 0664 N645EXSkelton Joel G · Panama City Beach, FLS/N 0645 N6522Uaa International Inc · La Verne, CAS/N 0522

Back to AD 88-26-01 R2