OpenAirDocs.org
AD 2005-02-01

Registered aircraft · 218

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

N1018QLambert Brent · Roanoke, VABuilt 2009 · S/N 421018N1019KPreferred Flight Management LLC · Goshen, INBuilt 2008 · S/N 421004N101PMKasper John D · Oxford, ALBuilt 2004 · S/N 42055N102FPN9817k LLC · Fredericksburg, VABuilt 2006 · S/N 42511N103FPStyle Ventures LLC · Lafayette, LABuilt 2006 · S/N 42512N104FPAutowashlbt LLC · Lumberton, NCBuilt 2006 · S/N 42513N1088DSpf America LLC · Fort Smith, ARBuilt 2009 · S/N 421015N1097LInternational Air Services Inc Owner Trustee · Carson City, NVBuilt 2008 · S/N 421006N1112LGunrunner 15 Air LLC · Hilton Head Island, SCBuilt 2009 · S/N 421017N1137ASleepwalker Aviation LLC · Wilmington, DES/N 42567N113FPPrice Ricardo Andres · Granbury, TXBuilt 2007 · S/N 42546N115FPBas Part Sales LLC · Greeley, COBuilt 2007 · S/N 42552N1170BHooper Jonathan · Andrews, NCS/N 42563N117FPCross Timbers Holdings LLC · Dover, DEBuilt 2007 · S/N 42553N1213MOlson Sandra K · Edmonds, WABuilt 2006 · S/N 42543N121TBRecovery Room LLC · Smyrna, GABuilt 2006 · S/N 42540N1222GNational Aerotech Aviation Delaware Inc · Wilmington, DES/N 42554N1267JN703fb Corp Trustee · Wilmington, DEBuilt 2007 · S/N 42509N1268RAyres Robert Paul · Okeechobee, FLBuilt 2006 · S/N 42530N1269EDestin Operating Co Inc · Lafayette, LABuilt 2006 · S/N 42522N1271BVan Dyck Philip · Athens, GAS/N 42529N1278DRegistered aircraftBuilt 2007 · S/N 42532N127DRKlamecki Alan P · Phoenix, AZBuilt 2001 · S/N 40028N1298GMango Tango Air LLC · Cantonment, FLBuilt 2007 · S/N 42533N12XYShramek Troy · Bossier City, LABuilt 2007 · S/N 42545N1321CClark Charles G · Catlettsburg, KYBuilt 2006 · S/N 42517N13331Cjc Aviation Inc Trustee · Wilmington, DEBuilt 2006 · S/N 42528N1334XGiannetti Nicholas · Charlotte, NCBuilt 2007 · S/N 42510N137GBCalm Air Aviation · Nunica, MIBuilt 2006 · S/N 42538N1393WWvl Aviation Inc · Wilmington, DEBuilt 2006 · S/N 42531N1411GTd Investments LLC · Oakdale, CAS/N 42556N1415KColumbia N1415k LLC · Leesburg, INBuilt 2006 · S/N 42547N1417WInternational Air Services Inc Trustee · Carson City, NVS/N 42523N141AMMckendrick Ain · Redwood City, CABuilt 2002 · S/N 40038N141PBL&M Columbia 181 LLC · Chandler, AZS/N 42066N142LCAerocareers Nfp · Columbia, ILBuilt 1998 · S/N 40003N1443TGrasso John A · Mount Laurel, NJBuilt 2007 · S/N 42534N144AEMinard Stephan · Queen Creek, AZBuilt 2002 · S/N 40042N151LCNewberry Homes LLC · Port Orange, FLBuilt 2007 · S/N 42501N156JBSully Air LLC · Atlanta, GABuilt 2001 · S/N 40019N1584YBacsikin Steven Kurt · Marine City, MIS/N 42564N166DSJagar Holdings LLC · Fort Worth, TXS/N 42070N16VABs LLC · North Vernon, INBuilt 2003 · S/N 42008N171TBMaritime Aviation Security Team · Wilmington, NCBuilt 2002 · S/N 40045N173KTCrawford Chris M · North Dinwiddie, VAS/N 40035N1800HSanders Trent J · Redway, CABuilt 2003 · S/N 42009N190DWSouthern Sky Ventures LLC · Lewes, DEBuilt 2003 · S/N 42002N191DWLexo Enterpirses · Houston, TXBuilt 2003 · S/N 42022N193DWGilbert Louis Vincent · Houston, TXBuilt 2004 · S/N 42043N1KVParagon Aviation LLC · Greenland, NHBuilt 2003 · S/N 40063
Back to AD 2005-02-01