Registered aircraft · 3,126

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

N522LLRegenald Michaud Aviation LLC · Willows, CABuilt 2013 · S/N 802-0532 N522MKTurbines Ltd · West Point, NEBuilt 2000 · S/N 4636284 N522TGSe Express LLC · South Lyon, MIBuilt 1985 · S/N BB-1209 N522WDPegasus Air LLC · Plainville, CTBuilt 1980 · S/N 4250015 N523BFPadgett Ag Rotors LLC · Missoula, MTBuilt 2017 · S/N 802A-0689 N523RBAnderson Interests LLC · East Bernard, TXBuilt 2014 · S/N 802A-0575 N5245FAex Aviation LLC · Davenport, FLBuilt 1965 · S/N LJ-92 N524GMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N BL-142 N524GTTyler Rental Inc · Ketchikan, AKBuilt 2003 · S/N 524 N524MRMt King Air · Stevensville, MTBuilt 1979 · S/N BB524 N524PMSky Train Air LLC · Templeton, CABuilt 2000 · S/N 46-97024 N525DFBleu Cheese Aviation II LLC · Addison, TXBuilt 2000 · S/N FL-306 N527BYR & R Flight Service Inc · Mendota, ILBuilt 2018 · S/N 602-1291 N527CHSafeco Leasing LLC · Port Alsworth, AKBuilt 1981 · S/N BB-899 N527FRRoma Air Corp · Belle Glade, FLBuilt 2016 · S/N 802A-0681 N527PBDavidson Investments LLC · Oklahoma City, OKBuilt 2003 · S/N 527 N527PKAir Care Leasing LLC · Lamar, COBuilt 1998 · S/N 402A-1067 N528JCFarm Air Inc · Astoria, ILS/N 602-0528 N528MBPorter Flying Service LLC · Missoula, MTS/N 802A-0350 N528PMIrg Aero LLC · El Paso, TXBuilt 2005 · S/N 653 N529PMCarolina Express LLC · Fairmont, MNS/N 46-97029 N5303VCaprock Spraying Inc · Vega, TXBuilt 2010 · S/N T65HG-026 N530CMPacific Valley Aviation Inc · Arbuckle, CABuilt 2017 · S/N 802A-0680 N530HPCreek Canyon Aviation LLC · Phoenix, AZBuilt 2001 · S/N 4697101 N530WCLaboratory Corporation Of America Holdings · Burlington, NCBuilt 2003 · S/N 530 N5320NSaunders Aviation LLC · Lewes, DEBuilt 2003 · S/N 4697153 N5322DBlack Phoenix Photography LLC · Morgan Hill, CABuilt 2001 · S/N 4697074 N5322MFlight Club LLC · Erie, PABuilt 2000 · S/N 4697021 N532AWCsi Aviation Inc · Killeen, TXBuilt 1991 · S/N FA-218 N532MCAlpha Ag Air LLC · Little River, KSBuilt 2005 · S/N 502B-2594 N53369Poor Boy Aero LLC · Seminole, TXBuilt 2001 · S/N 4697088 N5339G5339g LLC · Vero Beach, FLFirst renewal noticeBuilt 2001 · S/N 4697095 N53516Flight Group LLC · Bend, ORBuilt 2002 · S/N 4697132 N5353VMidwest Ventures LLC · Wichita, KSBuilt 2002 · S/N 4697141 N5355SJohn Galt Industries LLC · Charlevoix, MIBuilt 2002 · S/N 4697136 N535BBFlying Bar B LLC · Sandy, UTBuilt 2004 · S/N 596 N535MCMcintyre Flying LLC · Angleton, TXS/N 802A-0526 N535MKCapital Holdings 205 LLC · Northampton, PABuilt 2003 · S/N 535 N535PNDavis Aviation Inc DBA · Brandon, MSS/N FA-152 N537JFRad Aviation II LLC · Baton Rouge, LABuilt 2004 · S/N 537 N538BHRegistration Pending · Stone Harbor, NJRegistration pendingBuilt 2005 · S/N 626 N53993United States Government · Fort Belvoir, VAFirst renewal noticeBuilt 1985 · S/N 104 N53ARGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N BB-1629 N53BAIvester Drywall & Painting Inc · Salisbury, NCBuilt 1979 · S/N BB-426 N53GA52 Whiskey LLC · Elkhart, INBuilt 1985 · S/N BB-1201 N53KADesert Mountain Air LLC · Kalispell, MTBuilt 1981 · S/N BB-880 N53KBHiers Properties Of Delaware LLC · Chattanooga, TNBuilt 2005 · S/N 4697231 N53UPhenphilo3 LLC · Wilmington, DEBuilt 2000 · S/N 208B0855 N540MAN540ma LLC · Metairie, LABuilt 2001 · S/N BB-1765 N54199Key Aviation Group LLC · Meridian, MSBuilt 2003 · S/N 4697164

Back to AD 2016-05-13