OpenAirDocs.org
AD 2009-08-05 R1

Registered aircraft · 51

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
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:2009-08-05-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:2009-08-05-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.

N100XNMacwan Mahendra · Fleming Island, FLBuilt 2008 · S/N 0100N143ALPendergrass Jean M · Corpus Christi, TXBuilt 2006 · S/N 0035N19ETTerris Edward A · Oakdale, CTBuilt 2007 · S/N 0091N207AUHale John W · Fredericksburg, VABuilt 2008 · S/N 0105N258LCFund Av Consulting LLC · Morrisville, NCBuilt 2007 · S/N 0080N275MCRamos Luis M · Cabo Rojo, PRBuilt 2005 · S/N 0010N445KBMahoney Patrick J · Oxford, MSBuilt 2008 · S/N 0103N456HBXl2 Management LLC · Hackensack, NJBuilt 2006 · S/N 0040N518XLInternational Air Services Inc Trustee · Carson City, NVBuilt 2006 · S/N 0013N521XLLavion LLC DBA · Zeeland, MIBuilt 2006 · S/N 0018N524XLS&H Holdings LLC · Bridgeport, WVBuilt 2006 · S/N 0020N527XLDragon Flight Training Academy LLC · Pembroke Pines, FLBuilt 2006 · S/N 0022N529XLPowell Charles B · Bronson, TXBuilt 2006 · S/N 0023N530XLBankole Megan · Waukee, IABuilt 2006 · S/N 0024N532XLHuppert Frederick J · Oneida, TNBuilt 2006 · S/N 0026N533XLBloom Charles · Williamsburg, VABuilt 2006 · S/N 0027N537XLLa Claie Productions Inc Trustee · Geneva 15 AirportBuilt 2006 · S/N 0031N539XLBrayman Aviation LLC · Hollister, MOS/N 0032N540XLLenza George W · Greenville, SCBuilt 2006 · S/N 0033N541XLMeleg Christopher Sandor · Lebanon, TNBuilt 2006 · S/N 0034N547XLPamair LLC · Blue Bell, PAS/N 0037N549XLSmall Philip W · Florence, SCBuilt 2006 · S/N 0038N553XLLopez Gabriel A Trustee · El Monte, CABuilt 2006 · S/N 0043N554XLEstes Gary · Twin Lakes, WIS/N 0045N556XLSmith Caleb G · Forest, VABuilt 2007 · S/N 0046N566XLSchutz Raphael P · Miami Beach, FLS/N 0051N570XLDragon Flight Training Academy LLC · Pembroke Pines, FLBuilt 2007 · S/N 0055N572XLTabor Earl T · Kentwood, LAS/N 0057N576XLLa Claie Productions Inc Trustee · GenevaBuilt 2007 · S/N 0060N577XLXl2 Liberty LLC · Charleston, SCS/N 0061N578XLLa Claie Productions Inc · GenevaBuilt 2007 · S/N 0062N579XLBonura Rocco F · Perkinston, MSBuilt 2007 · S/N 0063N57NYTaylor Aviation Inc · Montgomery, NYBuilt 2006 · S/N 0030N581XLPgm Liberty LLC · Melbourne Beach, FLS/N 0067N583XLCarrasco Diego · Gresham, ORBuilt 2007 · S/N 0068N588XLSky High Flight LLC · Hampton, NHBuilt 2007 · S/N 0072N591XLLavion LLC DBA · Zeeland, MIBuilt 2007 · S/N 0075N592XLGiampro Corp · Rochester, NYBuilt 2007 · S/N 0044N602XLSeim Christopher Z · Omaha, NES/N 0079N605XLRegistered aircraftBuilt 2007 · S/N 0081N608XLDragon Flight Training Academy LLC · Pembroke Pines, FLBuilt 2007 · S/N 0084N611XLAerospace Trust Management LLC Trustee · Wilmington, DES/N 0087N637XLMcallister William · Commerce Township, MIBuilt 2008 · S/N 0108N643XLTw Brothers LLC · Loveland, COBuilt 2008 · S/N 0113N645XLMahoney Robert G · Fairborn, OHBuilt 2008 · S/N 0115N649XLLiberty 649xl LLC · Edgemoor, SCS/N 0119N653XLLa Claie Productions Inc Trustee · GenevaBuilt 2008 · S/N 0123N771SFFlammini Steven · Mansfield, MABuilt 2006 · S/N 0016N778KFBlair Kenton · Clinton, ARBuilt 2006 · S/N 0017N861XLMueller Jahn P · Honolulu, HIBuilt 2007 · S/N 0049
Back to AD 2009-08-05 R1