Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N824DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31935 N824MGAti Jet Inc · El Paso, TXBuilt 1984 · S/N 106 N824NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30916 N824SYSun Country Inc · Minneapolis, MNBuilt 2005 · S/N 33976 N824UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-923 N824VVOmega Air Inc · San Antonio, TXS/N 47824 N8256HGj Flight Group LLC · Newark, DEBuilt 1991 · S/N E-2664 N8257HS And G Ventures LLC · Wilmington, DEBuilt 1992 · S/N TH-1650 N825AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36699 N825BLTailwinds LLC · Houston, TXBuilt 2012 · S/N FL-810 N825DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31936 N825ECPeterson Air LLC · Chisago City, MNBuilt 1999 · S/N E-3272 N825JFVendito LLC · Lewes, DEBuilt 1986 · S/N E2329 N825KASav Aviation LLC · Jacksonville, TXS/N BB-825 N825MASouthern Airways Pacific LLC · Addison, TXBuilt 2013 · S/N 208B5065 N825MT376sb LLC · Lexington, KYBuilt 2014 · S/N 525-0825 N825NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31087 N825PSDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 501-0224 N825QTKjm Air LLC · Aurora, ILBuilt 2000 · S/N 258497 N825SDGreat Valley Management Inc · New Castle, DEFirst renewal noticeBuilt 1996 · S/N LJ-1449 N825STLowcountry Aviation Co Brokerage LLC · Walterboro, SCBuilt 1989 · S/N BB-1320 N825TTBank Of Utah Trustee · Salt Lake City, UTS/N FL-490 N825UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-925 N825UWConcept Jet Services Inc · Gainesville, FLBuilt 1985 · S/N 650-0082 N825VGarmin At Inc · Salem, ORBuilt 1977 · S/N E-963 N825WKMadunn El LLC · Wayzata, MNBuilt 1980 · S/N 025 N8261K8th Street Aviation LLC · Urbandale, IABuilt 1992 · S/N E-2690 N8261VTds Airpro LLC · Shreveport, LABuilt 1992 · S/N E-2691 N8264Wright Air Service Inc · Fairbanks, AKBuilt 2016 · S/N 208B5264 N8265XOzark Management Inc · Columbia, MOBuilt 1993 · S/N E-2804 N8269VN8269v Inc · Lewes, DEBuilt 1993 · S/N E-2796 N826ACTwin City Jets LLC · Wilmington, DEBuilt 1993 · S/N 560-0242 N826CMKuriel Michael · Las Vegas, NVS/N 421C0508 N826DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31937 N826FPMango Air 2 LLC · Oxnard, CABuilt 2000 · S/N FL-284 N826LMXuno Aviation LLC · Fort Lauderdale, FLBuilt 2019 · S/N 525-1046 N826MGOrten Symer Enterprises Inc · East Hampton, NYBuilt 1993 · S/N E2782 N826NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31089 N826RTHunter Resources LLC · Bossier City, LABuilt 1981 · S/N 551-0056 N826UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-926 N826VVOmega Air Inc · San Antonio, TXS/N 47826 N826WGSibi LLC · Indianapolis, INBuilt 2000 · S/N BB-1710 N826XTransport Services LLC · Birmingham, ALBuilt 1985 · S/N 826 N8272BAndy-Oxy Co Inc · Asheville, NCBuilt 1990 · S/N TH-1601 N8275ASigillito Michael A · Vero Beach, FLBuilt 1993 · S/N E-2803 N8277DValiair Lc Trustee · Casper, WYS/N E-2798 N8278TRegistered aircraftBuilt 1992 · S/N TH-1672 N827DLGa Ventures LLC · Scott, LABuilt 1986 · S/N FA-103 N827DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31938 N827EBEbor Management Inc · Alpharetta, GABuilt 1970 · S/N TH-135

Back to AD 2006-16-18 R1