Skip to content

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N447MKNorth Star Aviation Inc · Mankato, MNBuilt 2019 · S/N 4496459 N447TThompson Systems Inc · Amana, IABuilt 1969 · S/N 27-4288 N4482YMiller Andy D · Marana, AZS/N 25-4140 N4483CRich Aden Gene · Sequim, WABuilt 1959 · S/N 24-1257 N4484YMasterwings LLC · Princeton, KYBuilt 1966 · S/N 25-4144 N4486YQuality Aviation Inc · Marana, AZBuilt 1966 · S/N 25-4147 N4487PAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1962 · S/N 23-2009 N4487YWitthuhn Johnie B · Callaway, NEBuilt 1966 · S/N 25-4150 N448BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496607 N448JAGood Flight Aviation LLC · Stockton, CABuilt 1996 · S/N 4496011 N448MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 4496518 N4490PWelke Aviation Inc · St James, MIBuilt 1962 · S/N 23-2012 N4490YMinnesota Soaring Club Inc · Stanton, MNBuilt 1966 · S/N 25-4154 N4494FBella'S Business LLC · Kalispell, MTBuilt 1959 · S/N 23-1815 N4494PSimon Mitchell B · Edison, NJBuilt 1961 · S/N 23-2016 N4494YBegrow Adroaldo D · Gulf Shores, ALBuilt 1966 · S/N 25-4161 N4495YMerlin Soaring Association Inc · Amelia Court House, VABuilt 1966 · S/N 25-4162 N4496PPerez Amaro Angel L · Arecibo, PRBuilt 1960 · S/N 232011 N4496YHill Kenneth G · Pocatello, IDBuilt 1966 · S/N 25-4166 N4497PMatthews Aviation LLC · Hardinsburg, KYBuilt 1961 · S/N 23-2020 N4499PTls Aviation · Marysville, WABuilt 1961 · S/N 23-2022 N449BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496608 N449MKNorth Star Aviation · Mankato, MNBuilt 2022 · S/N 4496534 N449PAChristiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 4496185 N44FDHildreth David M · Kennesaw, GABuilt 1956 · S/N 23-500 N44PCGenocchio Anthony F · New Port Richey, FLBuilt 1965 · S/N 24-4124 N44PMPhipps Johnny · Salem, ORBuilt 1952 · S/N 22-726 N44PPKnr Inc · Evanston, WYBuilt 1955 · S/N 22-2576 N44PTDaedalus Flight Service Inc · P FokaiaBuilt 1972 · S/N 27-4793 N44WDDemray William S · Northville, MIBuilt 1969 · S/N 30-1860 N4500ZBielefeld James L · Kenai, AKBuilt 1960 · S/N 22-8000 N4502ZBoyer Bruce A · Toledo, OHBuilt 1960 · S/N 22-8002 N4503ZDoran Daniel E · Lake In The Hills, ILS/N 22-8003 N45050Rav Aviation LLC · Miramar, FLBuilt 1969 · S/N 27-4271 N4505ASteadman Norman W · Arlington, TXBuilt 1956 · S/N 22-3810 N4506APennsylvania College Of Technology · Williamsport, PAS/N 22-3811 N4508ABonogofsky Thomas L · Bridger, MTBuilt 1956 · S/N 22-3813 N4509ZLawrence Bobby L · Willis, TXBuilt 1960 · S/N 22-8011 N450ASConroy Philip L · Colleyville, TXBuilt 1978 · S/N 27-7854123 N450JAHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 4496150 N450MKNorth Star Aviation Inc · Mankato, MNBuilt 2022 · S/N 4496546 N450PMStroede Scott E · King Salmon, AKBuilt 1958 · S/N 22-6206 N450VVCarver Aero LLC · Muscatine, IABuilt 2002 · S/N 4496113 N4510AGarvey James R · Fairhope, PABuilt 1956 · S/N 22-3815 N4510ZLamphere Michael T · Whitehall, NYBuilt 1960 · S/N 22-8012 N4511ZKim Andrew · Upland, CABuilt 1960 · S/N 22-8013 N4512YNohrenberg Redge O · Pingree, NDBuilt 1966 · S/N 25-4078 N4513YAlbertson James M · Slocomb, ALBuilt 1966 · S/N 25-4019 N4515PFlying W Leasing Inc · Bartlett, ILBuilt 1960 · S/N 27-18 N4515TSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2002 · S/N 4496115

Back to AD 85-02-05 R1