Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N6037AMehl Deborah R · Harsens Island, MIBuilt 1956 · S/N 28637 N60395American Aviation Inc · Brooksville, FLBuilt 2006 · S/N 172S10226 N60397Vector USA LLC · Olive Branch, MSBuilt 2006 · S/N 172S10227 N603EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12701 N603NDFm Aviation Services LLC · Arlington, VABuilt 2012 · S/N 172S11254 N6040AOlaf LLC · Bellbrook, OHBuilt 1956 · S/N 28640 N6041AKlosterman Aviation LLC · Celina, OHS/N 28641 N6041RStanley Herb · Morgan City, LABuilt 1965 · S/N 17253710 N6042AWoods Richard C · Raeford, NCS/N 28642 N6042NCal Aggie Flying Farmers · Davis, CABuilt 2006 · S/N 172S10228 N6042RMetz Jonathan M · Corpus Christi, TXBuilt 1965 · S/N 17253711 N6042ZL&G Skycatcher LLC · Bradenton, FLBuilt 2006 · S/N 172S10230 N6043AGriffin Tiffany J · Collinsville, OKBuilt 1956 · S/N 28643 N6043RDelage Enterprises · Dent, MNBuilt 1965 · S/N 17253712 N6044RLee Brett · Austin, TXBuilt 1965 · S/N 17253713 N6045AFleischman Matthew A · Moab, UTBuilt 1956 · S/N 28645 N6046ADickerson Danny W · York, SCBuilt 1956 · S/N 28646 N6047AJames Theodore B · Marine St Crx, MNS/N 28647 N6047RSwanson Brad J · Yakutat, AKBuilt 1965 · S/N 17253716 N6048ZRegistration Pending · Wilmington, DERegistration pendingBuilt 2006 · S/N 172S10217 N6049AMetcalf Nate J · Hooker, OKBuilt 1956 · S/N 28649 N6049RSmith Timothy John · Parkville, MDBuilt 1965 · S/N 17253718 N604EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12702 N604NDHeavy Metal Air LLC · Farmingdale, NYBuilt 2012 · S/N 172S11255 N604TTUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2008 · S/N 172S10735 N6051ABlair Marion J · Lafayette, LABuilt 1956 · S/N 28651 N6051RSpalding David · Ketchum, IDBuilt 1965 · S/N 17253720 N6051VBucelluni Brett · Cypress, TXBuilt 2006 · S/N 172S10245 N6052APhillips Roberta L · Riverside, CABuilt 1956 · S/N 28652 N6053ABalazs Marguerite · Devine, TXS/N 28653 N6053RBowen Zackary · Dallas, TXBuilt 1966 · S/N 17253722 N6054ABaker Travis L · Mount Pleasant, UTS/N 28654 N6054RHobbs William A · Cornelius, ORBuilt 1965 · S/N 17253723 N6056RMission Aviation Training Academy · Arlington, WABuilt 1965 · S/N 17253725 N6059ABradley Jesse C · Sheridan, MIBuilt 1956 · S/N 28659 N6059DLong Island Aviators LLC · Seaford, NYBuilt 2006 · S/N 172S10275 N6059RGlidewell Aviation Inc · Parkland, FLBuilt 2006 · S/N 172S10276 N605EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12706 N605MAAir Assets LLC · Orlando, FLBuilt 2000 · S/N 172S8605 N605SDMedary Aviation LLC · Brookings, SDBuilt 2024 · S/N 172S13271 N605WMZwl Consulting LLC · San Francisco, CABuilt 2020 · S/N 172S12488 N60603Christiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10277 N6060APowers Michael E · Sierra Madre, CABuilt 1956 · S/N 28660 N6060RRiviello Taylor · Costa Mesa, CAS/N 17253729 N60616Mustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10239 N6061ADickman Edward A · Melba, IDBuilt 1956 · S/N 28661 N6063ELawrence Aviation LLC · Overland Park, KSS/N 17271987 N6063RGarcia Pinedo Adolfo · Miami, FLBuilt 1965 · S/N 17253732 N6064RSvetfur Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10246 N6065AMam Air LLC · Stone Creek, OHBuilt 1956 · S/N 28665

Back to AD 90-06-03 R1