Skip to content

Registered aircraft · 10,639

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:99-01-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:99-01-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:99-01-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:99-01-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:99-01-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:99-01-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.

N3393ZWilliams Shane · Union, ORS/N 18-7279 N3394MBrown Harold J · Hobbs, NMBuilt 1947 · S/N 12-2059 N3394ZNord Margie N Trustee · Cantwell, AKBuilt 1960 · S/N 18-7281 N3395MPapendick Greg J · Hudsonville, MIS/N 12-2237 N3396ZPineland Holdings LLC · Gibsland, LABuilt 1960 · S/N 18-7285 N3397MSievert Randall L · Storm Lake, IABuilt 1947 · S/N 12-2248 N3399PThornton Curtis J · Ebro, FLBuilt 1954 · S/N 22-2380 N3399ZAsquith-Heinz Quinn · Juneau, AKBuilt 1960 · S/N 18-7254 N339TLeroux Todd C · Palmer, AKBuilt 1953 · S/N 18-2453 N33BGifford Steven K · Buskirk, NYBuilt 1946 · S/N 12-784 N33CBShepperson Frank Lester · Midwest, WYBuilt 1958 · S/N 18-6682 N33CMCharley Ernie · Gakona, AKBuilt 1976 · S/N 18-7609082 N33HKBarker Gerald E · Weymouth, MABuilt 1957 · S/N 18-6037 N3400AAirsmith Aviation LLC · Oshkosh, WIBuilt 1953 · S/N 22-1668 N3400ZHojnacki Frank · Hobart, INBuilt 1960 · S/N 22-7311 N3401WAerial Crop Protection Inc · Belle Glade, FLBuilt 1954 · S/N 18-4064 N3403ZCharpie Mark E · Ottawa Lake, MIBuilt 1960 · S/N 22-7314 N3404ALibby Stephen R Trustee · Anchorage, AKBuilt 1953 · S/N 20-1069 N3404ZDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1960 · S/N 22-7315 N3405ZHeinrich Steven A · Corvallis, ORBuilt 1960 · S/N 22-7317 N3407MBausch Wayne A · Ames, IABuilt 1947 · S/N 12-2253 N3407ZBug Smashers LLC · Winfield, KSS/N 22-7319 N3409ARhoades Charles E · Blessing, TXBuilt 1953 · S/N 22-1675 N3409MBelleau Clifford D · Anchorage, AKBuilt 1947 · S/N 12-2260 N3411ZBurroughs Garwin M · Yuma, AZBuilt 1960 · S/N 22-7324 N3412ZBeck Gary E · Richlands, NCBuilt 1960 · S/N 22-7325 N3414ANase Jeffrey D · Anchorage, AKBuilt 1953 · S/N 22-1683 N3414MNebrig & Associates Inc · Denton, TXBuilt 1947 · S/N 12-2061 N3414PHilil Inc · Smithville, TXBuilt 1958 · S/N 18-6772 N3414ZPulliam Anthony L · Lancaster, CABuilt 1960 · S/N 22-7327 N3416ATysland Lauren W · Madera, CABuilt 1953 · S/N 22-1684 N3416MBaker Marianne J · Raeford, NCS/N 12-2263 N3417ABishop Thomas W · Decatur, TXBuilt 1953 · S/N 22-1687 N3417MZiehvein Robert L Trustee · Belle Plaine, MNBuilt 1947 · S/N 12-2068 N3418MGrabin Joseph S · Jermyn, PABuilt 1947 · S/N 12-2281 N3419APaul Amy K · Anchorage, AKBuilt 1953 · S/N 22-1692 N3419PCiszak Larry T · Delevan, NYBuilt 1959 · S/N 18-6774 N3419ZVintage Piper LLC · Lexington, KYS/N 22-7332 N341AKGoddard Gary · Ohkay Owingeh, NMS/N 227411 N3421PLeever William L Trustee · Medford, ORBuilt 1958 · S/N 18-6775 N3424ZSemon Sheldon W · Galt, CABuilt 1960 · S/N 22-7337 N3425AMansell Matthew E · Napoleon, MOBuilt 1953 · S/N 22-1693 N3427YTradewind LLC · Wasilla, AKBuilt 1962 · S/N 18-7794 N3428AMorrissey Philip A · Templeton, MAS/N 22-1698 N3428ZHefner Ronald J · Plattsmouth, NES/N 22-7341 N3429ZWaters Dwayne R · Merritt Island, FLBuilt 1960 · S/N 22-7343 N342CAEastern Stearman Inc Trustee · Leesburg, VABuilt 1979 · S/N 18-8009005 N3432AHolbrook Joel P · Delta Junction, AKBuilt 1953 · S/N 22-1699 N3433MDixon Tom N · Lodi, CABuilt 1947 · S/N 12-2270 N3433ZKitchen Ronald L · Leasburg, MOFirst renewal noticeBuilt 1960 · S/N 22-7347

Back to AD 99-01-05 R1