Skip to content

AD 2005-05-53 R1

Registered aircraft · 6,036

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:2005-05-53-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:2005-05-53-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:2005-05-53-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:2005-05-53-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:2005-05-53-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:2005-05-53-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.

N216CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13077 N216LTWingsleasing LLC · Wichita, KSBuilt 1999 · S/N 172S8121 N216SPNavy Annapolis Flight Center Inc · Edgewater, MDBuilt 1999 · S/N 172S8216 N216TTKclj LLC · Dover, DEBuilt 2022 · S/N 18283197 N21705Bagamaspad Alan · Reseda, CABuilt 2004 · S/N 172S9699 N21706Spinks Flight Center Inc · Burleson, TXBuilt 2007 · S/N 172S10470 N2170WSacks Martin · Mill Valley, CABuilt 2005 · S/N T18208441 N21714Aero Equities LLC · Ventura, CABuilt 2007 · S/N 172S10471 N21718Blomgren David · Phoenix, AZBuilt 2004 · S/N 172S9645 N2171XGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 2004 · S/N 172S9655 N21722Western Properties Investors And Advisors LLC · Laguna Niguel, CABuilt 2004 · S/N T18208261 N2172JTaylor A Pharr Esq LLC · Alexander City, ALBuilt 2004 · S/N T18208250 N2172WGo Around LLC · Elburn, ILBuilt 2007 · S/N T18208704 N21733Bradley Ralph W Jr · Newbury Park, CABuilt 2007 · S/N T18208706 N2173ERiva LLC · Sioux Falls, SDBuilt 2004 · S/N 18281351 N2173ZTegridy Equipment Leasing LLC · Aurora, ORBuilt 2004 · S/N 17281216 N21744Oatdog Aviation LLC · Atlanta, GABuilt 2004 · S/N T18208255 N21746Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N T18208462 N2174911:11 Enterprises LLC · San German, PRBuilt 2004 · S/N 18281348 N2174VRjr Leasing LLC · Wilmington, DEBuilt 2005 · S/N 18281661 N2175WIndustry Machine Design & Automation Inc · Camarillo, CABuilt 2005 · S/N T18208463 N2176STango-Alpha LLC · Saint Charles, MOBuilt 2004 · S/N T18208256 N21778Nodak Aircraft Leasing LLC · Fargo, NDBuilt 2007 · S/N 172S10483 N2177QKovarik Lucas M · Ord, NES/N 18281347 N21796Seegmiller Geoffrey · Houston, TXBuilt 2004 · S/N T18208329 N2179MKairez Carolyn E · Punta Gorda, FLBuilt 2005 · S/N T18208466 N217EPEpic Aviation Inc · New Smyrna Beach, FLFirst renewal noticeBuilt 2017 · S/N 172S12006 N2181AL&C Ventures LLC · Clovis, NMBuilt 2005 · S/N T18208467 N2181NState Of Oregon · Salem, ORBuilt 2004 · S/N 18281339 N2182FKleen Sheen IV LLC · Bowling Green, KYBuilt 2004 · S/N 18281340 N2182KDura Built LLC · Greensburg, KYBuilt 2005 · S/N T18208469 N2183JMichael Nehring Inc · Mohall, NDBuilt 2004 · S/N 172S9631 N2183PBarney Northcote Inc · Riverside, CABuilt 2005 · S/N T18208470 N2192PSandoval Tax Cpas Inc · Bakersfield, CABuilt 2005 · S/N 18281668 N2193WAzalea Utilities Inc · Summerville, SCBuilt 2005 · S/N 18281670 N2194LState Of Wisconsin · Madison, WIBuilt 2005 · S/N 18281672 N21964Matt Anchordoguy Co LLC · Vina, CABuilt 2007 · S/N 18281945 N2196LAerolisse LLC · Chouteau, OKBuilt 2005 · S/N T18208478 N21971Mp Aviation LLC · Buffalo, NYBuilt 2007 · S/N T18208730 N219CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13080 N219CEGillison William · Lake Village, ARBuilt 2023 · S/N 18283219 N219MCHansen Todd · Friday Harbor, WABuilt 2004 · S/N 18281323 N219PDWolfair LLC · Lewes, DEBuilt 2005 · S/N 18281665 N219SB155 Aviation LLC · Redwood City, CABuilt 2006 · S/N T18208598 N219SPLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1999 · S/N 172S8219 N21LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2001 · S/N 172S8936 N21SZVista Air Inc · Pacoima, CABuilt 1998 · S/N 17280653 N2200FQualitair LLC Trustee · MichelstadtBuilt 2007 · S/N T18208732 N2202QLewis University · Romeoville, ILBuilt 2007 · S/N 172S10517 N22044182 Flight Corp · Bronx, NYBuilt 2005 · S/N 18281671

Back to AD 2005-05-53 R1