Skip to content

Registered aircraft · 85,612

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N2861HStalvey Daron K · Conway, SCS/N 28-7921077 N2861QBlackmon Robert · San Antonio, TXBuilt 1971 · S/N 17259861 N2861TDesert Sky Flight Group Inc · Tucson, AZBuilt 1972 · S/N 28R-7235147 N2861VBeck Roger M Trustee · Goode, VABuilt 1947 · S/N D-266 N2861WAustin And Austin Inc · Stafford, KSBuilt 1973 · S/N E-448 N28627Key City Fliers Inc · Maquoketa, IAS/N 28-7990420 N2862APrecious Heir Holding Company LLC · Tucson, AZBuilt 1979 · S/N 28-7916486 N2862FFoxtrot Partners LLC · West Bountiful, UTBuilt 1966 · S/N 18256962 N2862RGuthrie Devin L · Sallisaw, OKBuilt 1967 · S/N 18258462 N2862TReed Thomas F · Maize, KSS/N 28R-7235148 N2862UWallace Jon W · Ozark, ARBuilt 1963 · S/N 17250462 N2862WBonanza 62w LLC · Richmond, INBuilt 1973 · S/N D-9504 N2862YDickson Troy S · Placerville, CABuilt 1962 · S/N 18253862 N2863ASkipper Jonathan H · Fayetteville, GABuilt 1953 · S/N 30063 N2863EWetherley Aviation LLC · Boise, IDBuilt 1978 · S/N 17271352 N2863FWright William J · Raeford, NCBuilt 1966 · S/N 18256963 N2863MBaillie Ryan B · Hermitage, TNBuilt 1977 · S/N 28-7816318 N2863PGic Inc · Oneill, NEBuilt 1979 · S/N 28-7990504 N2863QSalsbery Randall E · Sharpsville, INBuilt 1971 · S/N 17259863 N2863UEady Paul Clifford · Lakeside, CABuilt 1979 · S/N 28-7990505 N2863VBfree2fly LLC · Delaware, OHBuilt 1979 · S/N 28-7990506 N2863WWarrick Motors LLC · Newton, IABuilt 1973 · S/N CE-451 N2863YPiontek Claudia A · Henderson, NVBuilt 1962 · S/N 18253863 N2864CRegistration Pending · Bloomington, ILRegistration pending, pending cancellationBuilt 1954 · S/N 26407 N2864FPreszler Sharon J · Mesa, AZBuilt 1966 · S/N 18256964 N2864LTakle Management LLC · Bethany, OKS/N 17256064 N2864QEaglet Flight Operations Lp · Fort Worth, TXBuilt 1971 · S/N 17259864 N2864YAnderson Bruce A · Seville, OHBuilt 1979 · S/N 28-7911211 N28652J & N Aviation LLC · Marion, IAS/N 28-7990421 N2865FMctaggart Briar · Oroville, CAS/N 18256965 N2865LIfr LLC · Springfield, MOBuilt 1967 · S/N 17256065 N2865QLasalle Charles H · Williamstown, NYBuilt 1971 · S/N 17259865 N2865RCarmel Aviation Inc · Boise, IDBuilt 1969 · S/N 28R-35308 N2865VDekker Paul R · Port Saint Lucie, FLS/N 28-7921044 N2865YSinclair Maurice A · Melrose, IAFirst renewal noticeBuilt 1962 · S/N 18253865 N28667Rehberg Eric · Chattanooga, TNBuilt 1979 · S/N 28-7990422 N2866ATruman Sparks Aviation LLC · Snyder, TXBuilt 1953 · S/N 30066 N2866FHowell Thomas F · Red Bluff, CAS/N 18256966 N2866KDobransky Robert J · Peoria, AZBuilt 1979 · S/N 18053104 N2866LRegistration Pending · Spring Branch, TXRegistration pendingBuilt 1967 · S/N 17256066 N2866QAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1971 · S/N 17259866 N2866RCw Arborists Ltd · Sagaponack, NYBuilt 1969 · S/N 28R-35309 N2866TPacific Coast Air Museum · Santa Rosa, CAS/N 28-7225258 N2866WBowman Field Flying Club Inc · Louisville, KYBuilt 1979 · S/N 28-7916489 N2867AShinkle Robert P · Sugar Creek Twnshp, OHBuilt 1979 · S/N 28-7916491 N2867CPlatt Ranch Inc · Kim, COBuilt 1954 · S/N 26410 N2867TN504fl LLC · Killeen, TXBuilt 1972 · S/N 28-7225259 N2867URegistered aircraftS/N 28-7916493 N2867YCook Kevin M · Hallettsville, TXBuilt 1962 · S/N 18253867 N2868ATaylor Eric C · Port Townsend, WABuilt 1953 · S/N 30068

Back to AD 98-21-21 R1