Skip to content

Registered aircraft · 54,017

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N48222N1705r Inc · Cobb, CAS/N 15283303 N48228M & L Utility Contractors Inc · Cottondale, FLBuilt 1979 · S/N 15283304 N4822DRegistered aircraftBuilt 1958 · S/N 34922 N4822GHighpoint Strategies LLC · Cypress, TXBuilt 1979 · S/N 17273370 N4822NBalinski Stephen W · Lusby, MDBuilt 1979 · S/N 18267394 N48237Yoder Airways LLC · Fayetteville, GABuilt 1967 · S/N R172-0171 N48238Hamilton Brandon T · Morehead, KYBuilt 1979 · S/N 15283306 N48239Harrell Robert L · Brooksville, FLBuilt 1979 · S/N 15283307 N4823LLaguna Verde Leasing Inc · Wilmington, DES/N 15284233 N4823VStratus Air LLC · New Orleans, LAFirst renewal noticeBuilt 1980 · S/N 172RG0391 N4823XVon Bernewitz David A · Myersville, MDBuilt 1966 · S/N 15064873 N48241Evans Christopher Warren · Demotte, INBuilt 1979 · S/N 15283308 N48244Kelly Kevin J · Lancaster, NYBuilt 1979 · S/N 15283310 N4824FWheeler Michael P · Declo, IDBuilt 1966 · S/N U206-0524 N4824GHickman Robert B · La Follette, TNBuilt 1979 · S/N 17273372 N4824PMikhailau Ivan · Alpine, UTBuilt 1980 · S/N 15284823 N4824XPowell Kevin D · Nampa, IDS/N 15064874 N4825DHitec Construction Services Inc · Lincoln, CABuilt 1958 · S/N 34925 N4825EParis Enterprises LLC · Atlanta, GABuilt 1979 · S/N 18503883 N4825FLober Richard M · Bishop, CABuilt 1966 · S/N U206-0525 N4825NBlue 79 LLC · Loogootee, INBuilt 1979 · S/N 18267397 N4826DTurbine Training Center Inc · Manhattan, KSBuilt 1958 · S/N 34926 N48270Stephenson Christopher J · Rindge, NHBuilt 1979 · S/N 15283315 N4827DWebber David A · Delta Junction, AKBuilt 1958 · S/N 34927 N4827PCarlson Chris · Redwood City, CABuilt 1978 · S/N P21000119 N4827UHagen Rainer · Irving, TXBuilt 1979 · S/N U20605119 N4827XPpy Fly Corp · Atlanta, GAS/N 15064877 N48286Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283320 N4828BGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1979 · S/N 15283660 N4828DNisbet William T · Driggs, IDBuilt 1958 · S/N 34928 N4828KFlywerx LLC · Anchor Point, AKBuilt 1979 · S/N P21000336 N4828PFlying Nam LLC · Sheridan, WYBuilt 1981 · S/N 17274828 N4828XGillette David L · Carrollton, TXFirst renewal noticeBuilt 1966 · S/N 15064878 N4829GSoaring Raven LLC · Seattle, WABuilt 1979 · S/N 17273377 N4829KCanal Flight LLC · Portland, ORBuilt 1979 · S/N P21000337 N4829NKcj Fly LLC · Fuquay Varina, NCBuilt 1979 · S/N 18267399 N4829PBoard Of Trustees Of University Of Illinois · Savoy, ILBuilt 1980 · S/N 15284824 N4829RThomas Michael W · Prescott, WABuilt 1978 · S/N R18200614 N482ALKcantarano LLC · Mulkilteo, WAS/N A1500223 N482EHb Coco & Company · Gonzales, TXBuilt 1979 · S/N 17272338 N48306Bargo Marvin Rae Jr · London, KYBuilt 1979 · S/N 15283323 N4830BRussell Dwight R · Milo, MEBuilt 1979 · S/N 15283661 N4830GHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1979 · S/N 17273378 N4830KRamaker LLC · Choteau, MTBuilt 1979 · S/N P21000338 N4830NSimansky Daniel W Trustee · Van Nuys, CABuilt 1979 · S/N 18267400 N48317Rhoden Gregory L · Sarasota, FLBuilt 1967 · S/N R172-0051 N4831DVogel Paul R · Valparaiso, INBuilt 1958 · S/N 34931 N4831FWillis Rodney S · Wasilla, AKBuilt 1966 · S/N U206-0531 N4831XSeebold Dustin K · Mifflinburg, PABuilt 1966 · S/N 15064881 N48322Stroemsvik Kristian · Strasburg, VAS/N R172-0213

Back to AD 87-20-03 R2