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.

N633CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11459 N633NDAyah Investments LLC · Kent, WABuilt 2013 · S/N 172S11292 N63405Christiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10849 N63419Aviation Training LLC · Wilmington, DEBuilt 2004 · S/N 17281224 N6341TGoose Leasing LLC · Ashburn, VABuilt 2008 · S/N 172S10843 N6342BFargo Jet Center LLC · Fargo, NDBuilt 2008 · S/N 172S10842 N6342XRainier Flight Service LLC · Renton, WABuilt 2008 · S/N 172S10845 N6345DRumble Aviation LLC · Thomasville, GABuilt 2004 · S/N 18281401 N63461Georgia Golf Cars Inc · Douglas, GABuilt 2004 · S/N 18281402 N6346ERudd Richard L · Cornelius, NCBuilt 2008 · S/N 18282144 N6348AGzs Aviation LLC · Dover, DEBuilt 2008 · S/N 18282145 N634CE3mc Aviation LLC · Diboll, TXS/N T18208634 N634CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281529 N634CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11460 N634GLVolar Xi LLC · Edmond, OKBuilt 2011 · S/N 172S11104 N634SJAmeriflyers Of Texas Inc · Addison, TXBuilt 2000 · S/N 172S8634 N6353MMont Belvieu Materials Inc · Mont Belvieu, TXS/N 18281403 N635BASvetfur Aviation LLC · Camden, SCBuilt 2015 · S/N 172S11596 N635BKGuilford County · Greensboro, NCBuilt 2003 · S/N 172S9554 N635CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281530 N635CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11461 N635CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283335 N635NDEveryday Airman LLC · Seattle, WABuilt 2013 · S/N 172S11294 N635SPAtp Aircraft 2 LLC · Wilmington, DEBuilt 2000 · S/N 172S8630 N636CBN636cb LLC · Bensenville, ILBuilt 2019 · S/N 172S12261 N636CMCaelum Et Terra LLC Series B · Evanston, ILBuilt 2021 · S/N 172S12657 N636CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281531 N636CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11462 N636EMAb Prop Plane II LLC · Metairie, LABuilt 2022 · S/N 172S12852 N636LSN636ls LLC · Bensenville, ILBuilt 2020 · S/N 172S12474 N636SAMustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9636 N6372BCm Air LLC · Wilmington, DEBuilt 2004 · S/N 18281404 N637CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281532 N637CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11463 N637RMOtn Skylane LLC · The Woodlands, TXBuilt 2012 · S/N 18282331 N6383CBurton Brandon · Canton, GABuilt 2004 · S/N 18281405 N638AGSkywest Leasing Inc · St George, UTBuilt 2014 · S/N 172S11464 N638CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281533 N638CTCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10781 N63921Nc Division Of Marine Fisheries · Morehead City, NCBuilt 2004 · S/N 18281408 N639CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281534 N639CTCoast Flight Training & Management Inc · San Diego, CABuilt 2008 · S/N 172S10780 N639EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2014 · S/N 172S11465 N639SPSpengler Raymond Francis Jr · Longview, TXBuilt 1998 · S/N 172S8047 N63JAWings Over Texas Holdings LLC · Denton, TXBuilt 2007 · S/N 172S10484 N63LUChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280591 N63SVTextron Aviation Inc · Wichita, KSS/N 172S13630 N63UDAlf Ix LLC · Chicago, ILBuilt 2017 · S/N 172S12090 N640CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281518 N640SPJet Air Inc · Iowa City, IABuilt 1998 · S/N 172S8048

Back to AD 2005-05-53 R1