Skip to content

AD 2005-05-53 R1

Registered aircraft · 6,038

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.

N7261ZChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9080 N7262XFlight School Of Gwinnett Inc · Lawrenceville, GAS/N 17280993 N72639Dischler Stephen · New Lisbon, WIBuilt 1999 · S/N 17280806 N72653Atp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280807 N7265BHolladay Aviation LLC · Jacksonville, FLBuilt 1999 · S/N 17280749 N7265YAv8r LLC · Manchester Center, VTBuilt 1999 · S/N 17280768 N7265ZAtp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280769 N72662Jwa Flight School LLC · Bolingbrook, ILBuilt 1999 · S/N 17280817 N72664Advanced Aviation Group LLC · Frederick, MDBuilt 1999 · S/N 17280818 N7266BButtonwood Construction LLC · Islamorada, FLBuilt 2001 · S/N T18208003 N72675Chapel Hill Flying Club Inc DBA · Sanford, NCBuilt 2001 · S/N 172S8977 N726CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11566 N726EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13029 N726LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13587 N726SAInternational Air Services Inc Trustee · Carson City, NVBuilt 2010 · S/N 18282221 N7273MPalm Beach Flight Training Corp · Lantana, FLBuilt 1999 · S/N 17280761 N72758Hinton Larry L · Kirkland, WABuilt 2001 · S/N T18208004 N7275CAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280503 N7275DMoody Bible Institute Of Chicago · Spokane, WABuilt 1999 · S/N 17280790 N7275REdb Air Inc · Wilsonville, ORBuilt 1999 · S/N 172S8026 N72780Dean'S Flight Inc · Pembine, WIS/N 18280954 N72788Christiansen Aviation LLC · Wilmington, DES/N 17280988 N72798Skylane 72798 LLC · Winston Salem, NCBuilt 2001 · S/N 18280946 N727CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282255 N727LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13590 N727NSBarrett Kemberly · Woodway, TXBuilt 2006 · S/N 18281809 N727SPElite Approach LLC · Chesterfield, MOBuilt 2000 · S/N 172S8664 N728AABrinckerhoff Allen D · Windermere, FLBuilt 2004 · S/N T18208249 N728EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13032 N728FGRidgeline Assets LLC · Wilmington, DEBuilt 2024 · S/N 172S13275 N728HVBig Bang Air LLC · Wichita, KSBuilt 2023 · S/N 18283223 N728LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13593 N728SPFleetshares N728sp Inc · Leesburg, VABuilt 2000 · S/N 172S8665 N729CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281757 N729EBoard Of Trustees Of Southern Illinois Universtiy · Carbondale, ILBuilt 2023 · S/N 172S12965 N729ELRegistered aircraftBuilt 2023 · S/N 18283209 N729LUTextron Aviation Inc · Wichita, KSS/N 172S13596 N729MTHochreiter Heinrich · Bellingham, WABuilt 1999 · S/N 172S8272 N729SPMars Aerospace Inc · Bay Shore, NYBuilt 2000 · S/N 172S8666 N72EFN72ef LLC · Canton, GABuilt 2000 · S/N 172S8636 N72FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12936 N72KFKirkpatrick John Drew · Post, TXBuilt 2004 · S/N 18281361 N72MCAa-Aero Inc · Fairfield, NJBuilt 2005 · S/N 18281653 N730EREmbry-Riddle Aeronautical Univeristy Inc · Prescott, AZBuilt 2023 · S/N 172S13036 N730LUTextron Aviation Inc · Wichita, KSS/N 172S13599 N731CLNby Productions · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282256 N731TBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12573 N732CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11568 N732LUTextron Aviation Inc · Wichita, KSS/N 172S13602 N7339MBroadwell Group Inc · Acworth, GABuilt 2022 · S/N 172S12918

Back to AD 2005-05-53 R1