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.

N6724AGodin George A · Franklin, VTBuilt 1956 · S/N 28824 N6727HAldora Enterprise LLC · League City, TXBuilt 1975 · S/N 17265558 N6729AO Tuel Maxcy Bryant · Mooresville, NCBuilt 1956 · S/N 28829 N672CCDmac Aircraft LLC · Savannah, GABuilt 1962 · S/N 17248796 N672EBAviation Associates Of Hanover LLC · Enfield, NHBuilt 2000 · S/N 172S8672 N672EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12695 N672FCBlackhawk Holding Corp · Wilmington, DEBuilt 1980 · S/N 17273897 N672MALewis University · Romeoville, ILBuilt 1999 · S/N 17280734 N672SPThomas Bahamas Airways LLC · Port Orange, FLBuilt 1999 · S/N 172S8085 N6732AHurst Construction Co · Denton, TXS/N 28832 N6733AJaed Gerald E · Yankeetown, FLS/N 28833 N6735AHinkle Robert J · Caldwell, IDBuilt 1956 · S/N 28835 N6735HWhitney Dudley P · Windsor, VTBuilt 1975 · S/N 17265559 N6736AFogleman Brian L · Stonewall, LABuilt 1956 · S/N 28836 N6737AEdmiston Dave L · Clifton, TXBuilt 1956 · S/N 28837 N6738ABufford David T · Union Springs, ALFirst renewal noticeBuilt 1956 · S/N 28838 N673DWSunrise Aviation Inc · Ormond Beach, FLBuilt 1999 · S/N 17280771 N673EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12732 N673JHAb Prop Plane II LLC · Metairie, LABuilt 2022 · S/N 172S12900 N673MALewis University · Romeoville, ILBuilt 1999 · S/N 17280741 N673SP673sp LLC · Blaine, MNBuilt 2000 · S/N 172S8633 N673XBusy Bee Ventures Inc · Cherokee, NCBuilt 1960 · S/N 17247922 N6740AWillis John Y · Pine Mountain, GABuilt 1956 · S/N 28840 N6742ABouton Vern H · Fairbanks, AKBuilt 1956 · S/N 28842 N6743AChenier Mark S · Goldsboro, NCS/N 28843 N6743HCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1975 · S/N 17265562 N6744ALa Rue Carl A · Cambridge, OHBuilt 1956 · S/N 28844 N6745PPinnacle Aviation Services Inc · Encinitas, CABuilt 1999 · S/N 172S8087 N6747AMatt Brit A · Sioux Falls, SDFirst renewal noticeBuilt 1956 · S/N 28847 N6747HAurora Skyhawks · Portland, ORS/N 17265564 N6748HN6748h LLC · Palm Beach Gardens, FLBuilt 1975 · S/N 17265565 N6749AOwens Wilbur · Rch Palos Vrd, CAS/N 28849 N674CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12153 N674DWSunrise Aviation Inc · Ormond Beach, FLBuilt 1999 · S/N 17280772 N674EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12736 N674MALewis University · Romeoville, ILBuilt 1999 · S/N 17280742 N6750AC & B Aerial Transport Inc · Wilmington, DEBuilt 1956 · S/N 28850 N6750HPickett Michael R · Gig Harbor, WABuilt 1975 · S/N 17265566 N6752AGray Shane Charles · Interlochen, MIS/N 28852 N6753AWickard Mark A · Bridgeport, NEBuilt 1956 · S/N 28853 N6755ASteffes Dennis J · Hershey, NES/N 28855 N6757AN7742e LLC · Lewes, DES/N 28857 N6758HGorge Winds Aviation Inc · Fairview, ORBuilt 1975 · S/N 17265570 N6759ACross Billy G · Glen Allan, MSBuilt 1956 · S/N 28859 N675EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12744 N6761ASkeen Steven L · Enterprise, ALBuilt 1956 · S/N 28861 N6761TMccarville Katherine A · Fayette, IABuilt 1960 · S/N 47261 N6765ANiehues Reid B · Eola, TXBuilt 1956 · S/N 28865 N6766ADenton Michael W · Clarksville, VABuilt 1956 · S/N 28866 N676CBElizabeth City State University · Elizabeth City, NCBuilt 2021 · S/N 172S12619

Back to AD 90-06-03 R1