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.

N84099650 Aviation LLC · San Mateo, CABuilt 1973 · S/N 18261853 N8409QFrey David G Jr · Grand Rapids, MIBuilt 1976 · S/N U20603269 N8409SKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1965 · S/N 18256509 N840DWKoesy Gregory W · Pembroke Pines, FLBuilt 1999 · S/N 18280464 N840LPMys Aviation LLC · Rockford, ILBuilt 2004 · S/N 18281483 N8410TYounkin Cindy E · Mc Allister, MTBuilt 1959 · S/N 52310 N8410ZA1 Aviation Group Inc · Geneva, FLS/N 205-0410 N8411TVan Kirk Kenneth Lee · Tucson, AZFirst renewal noticeBuilt 1959 · S/N 18252311 N8411ZJim Davis Enterprises Co · Wintersville, OHBuilt 1963 · S/N 205-0411 N8412SWaldron Roger H · Santa Barbara, CABuilt 1965 · S/N 18256512 N8412TSterling Flyers LLC · Lehi, UTS/N 52312 N8413SFlying Condors Inc · Templeton, CABuilt 1965 · S/N 18256513 N8414TDewante Robert R · Corvallis, MTBuilt 1959 · S/N 52314 N8416SSnow Ryan L · Hyrum, UTBuilt 1965 · S/N 18256516 N8416ZSwamp Fox Aviation LLC · Chapin, SCS/N 205-0416 N8418SSwanson Scott R · Sulphur Springs, TXBuilt 1965 · S/N 18256518 N8418TAmes Jimmy M · Collinsville, OKBuilt 1959 · S/N 52318 N8419TSummers Greg D · Sheridan, ORBuilt 1959 · S/N 52319 N8419ZMahal Pradeep S · Warren, NJBuilt 1963 · S/N 205-0419 N841DPSior David · Connelly, NYBuilt 1953 · S/N 16112 N841JLMarks Stephen M · Monument, COBuilt 1967 · S/N T210-0330 N841LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 20608341 N841RQMueller Steven L · Osceola, WIBuilt 1976 · S/N U20603273 N8420SBrackett Scott S · Kingman, AZS/N 18256520 N8420ZWilkerson Thomas R · Kent, WABuilt 1963 · S/N 205-0420 N8421TKammann Trevor R · Wellton, AZBuilt 1959 · S/N 52321 N8421ZSchmitt Rudy · Brookshire, TXBuilt 1963 · S/N 2050421 N8422SPhoenix Innovations Inc · Scappoose, ORBuilt 1965 · S/N 18256522 N8422TCrutchfield Utility Aviation LLC · Siloam Springs, ARBuilt 1959 · S/N 52322 N8422ZN8422z LLC · Farmington, NMBuilt 1963 · S/N 205-0422 N84239Wells Richard M · Hartford, KYBuilt 1973 · S/N 18261857 N8423SPatton Steven R · Wayne, OHBuilt 1965 · S/N 18256523 N8423ZCox Ronald A · Poplar Grove, ILBuilt 1963 · S/N 205-0423 N8424SSkylane V LLC · Santa Rosa, CABuilt 1965 · S/N 18256524 N8424WExtra Equipment Inc · Stuart, FLBuilt 1979 · S/N 21063732 N8425SDennehey Donald J Jr · Prior Lake, MNBuilt 1965 · S/N 18256525 N8426TKeller William T · Mcminnville, ORBuilt 1959 · S/N 52326 N8428MNervino David J · Hilmar, CABuilt 1976 · S/N 18264603 N8428TErtle Brian · Quitman, ARBuilt 1959 · S/N 52328 N8429SComm William C · Mulino, ORBuilt 1965 · S/N 18256529 N842DMCapps Steven M · Mount Pleasant, TXBuilt 1998 · S/N 18280161 N842TCWitte Transport LLC · West Plains, MOBuilt 2000 · S/N 18280841 N8430SPeterson Todd · El Dorado, KSBuilt 1966 · S/N 18256530 N8430TBullock David James · Wickenburg, AZBuilt 1959 · S/N 52330 N8432SCurzon Peter · Eugene, ORBuilt 1965 · S/N 18256532 N8432THouston Douglas L · Boise, IDBuilt 1959 · S/N 52332 N8432ZRogina Allen J · Shady Cove, ORBuilt 1963 · S/N 205-0432 N8433SGregory Ovel Lee IV · Wayzata, MNS/N 18256533 N8435SFrancis David S · Lakeside, CABuilt 1965 · S/N 18256535 N8435TThompson Dennis P · Coeur D Alene, IDS/N 52335

Back to AD 84-10-01 R1