Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N92638Van Raden Chris · Portland, ORBuilt 1970 · S/N 18260291 N92639Pryor Aviation LLC · Hutchinson, KSS/N 18260292 N9263GN9263g LLC · Marshall, MOS/N 18260803 N9263XMieloszyk Nicholas A · Elko, NVS/N 18253663 N92644Atkins Doug · Murfreesboro, TNBuilt 1970 · S/N 18260293 N92648Bender Phillip H · Bloomingdale, OHBuilt 1970 · S/N 18260295 N9265CComerford John W · Pagosa Springs, COBuilt 1955 · S/N 31364 N9265TFpg Agri Services LLC · Frost, TXBuilt 1960 · S/N 50765 N9265XWestern Pilot Service Inc · Phoenix, AZBuilt 1961 · S/N 18253665 N92665Rupke Curtis · Washington, NCBuilt 1970 · S/N 18260302 N9266GCole Mark A · Forest City, NCBuilt 1971 · S/N 18260806 N9266XWeichert Robert S · Parker, COS/N 18253666 N92675Miller Saima A · Kodiak, AKBuilt 1970 · S/N 18260305 N92677Burriss James E · Piedmont, SCBuilt 1970 · S/N 18260307 N9267GWaypoint Financial Services LLC · Raiford, FLBuilt 1971 · S/N 18260807 N9267TDeeds Andy · Larkspur, COFirst renewal noticeBuilt 1960 · S/N 50767 N92680E & T Research And Development LLC · Sanford, NCBuilt 1970 · S/N 18260308 N92690Nelson Richard B · San Mateo, FLBuilt 1970 · S/N 18260312 N92691Registration Pending · Lebanon, TNRegistration pendingBuilt 1970 · S/N 18260313 N9269TAlsworth Leon R · Port Alsworth, AKBuilt 1960 · S/N 50769 N926CSHardee Philip S · Florence, SCBuilt 1957 · S/N 34471 N926TCTango Charlie LLC · Gig Harbor, WABuilt 1997 · S/N 18280052 N926WBBender Walter F Jr · Virginia Beach, VABuilt 2000 · S/N 18280819 N92707Farquharson John L · Goldsby, OKS/N 18260319 N9270GFrye Warren S · Galax, VABuilt 1971 · S/N 18260810 N9270XCastle Rock Services LLC · Helena, MTBuilt 1961 · S/N 18253670 N92711Intergard R&D LLC · Miami, FLBuilt 1973 · S/N 21060024 N92712Pfister Michael J · Roanoke, ILBuilt 1970 · S/N 18260321 N9271CSowder Douglas A · Spokane, WABuilt 1955 · S/N 31370 N9271RUpwind Aviation LLC · Mitchell, SDBuilt 1978 · S/N R18200676 N92725Tucker Kyler T · Cypress, TXBuilt 1970 · S/N 18260329 N92726Gray Stanley Paul Jr · Temecula, CABuilt 1970 · S/N 18260330 N9272GSena James H · Edmond, OKBuilt 1971 · S/N 18260812 N9272TAkers Dana M · Kingston, NHBuilt 1960 · S/N 50772 N92739Mcmillin Michael C · Des Moines, IABuilt 1970 · S/N 18260335 N9273GPlisko Aviation LLC · Beaufort, NCBuilt 1971 · S/N 18260813 N92746Hansen Barbara · Armstrong, IAS/N 18260336 N9274XGawlik Leslie W · Reisterstown, MDBuilt 1961 · S/N 18253674 N92750Rauton Ken · Temecula, CABuilt 1970 · S/N 18260339 N92757Omegna Suzanne M · Spanaway, WABuilt 1970 · S/N 18260342 N92758Wayne Alan A · Flowery Branch, GABuilt 1970 · S/N 18260343 N92764Bernstein Jeffrey J · Swanton, MDBuilt 1970 · S/N 18260345 N92776Rivera Rivera Jose Manuel Trustee · Royal Palm Beach, FLBuilt 1970 · S/N 18260349 N9277CIrwin Phillip R · Parker, COBuilt 1955 · S/N 31376 N92787Quade James C · Duluth, MNBuilt 1970 · S/N 18260356 N92788Bas Part Sales LLC · Greeley, COS/N 18260357 N9279XKhoury Alain W · Wills Point, TXBuilt 1961 · S/N 18253679 N927NBlue Sky Business Services Inc · Gardiner, NYBuilt 1970 · S/N 18260320 N92814Kimbrell Tod L Jr · Itasca, TXBuilt 1970 · S/N 18260371 N92815Halver Todd L Trustee · Advance, NCBuilt 1970 · S/N 18260372

Back to AD 84-10-01 R1