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.

N2838ZHanrahan Andrew D · Soldotna, AKBuilt 1959 · S/N 22-6833 N2839DWhitehead Mark A · Valley Springs, CABuilt 1951 · S/N 22-244 N283THall Terry A · Pennsboro, WVBuilt 1953 · S/N 18-2397 N2840PBourne Steven M · Brooksville, FLBuilt 1955 · S/N 22-3137 N2841ZVan Ryn William C · Hermiston, ORBuilt 1959 · S/N 22-6836 N2842PEaster Brett D · Enumclaw, WABuilt 1955 · S/N 22-3139 N2844PZiller Michael W · Hudson, ILBuilt 1955 · S/N 22-3144 N2845MBrasher Kerry W · Scotts Hill, TNBuilt 1946 · S/N 12-1191 N2845ZKrause Douglas F · Stacy, MNBuilt 1959 · S/N 22-6840 N2846PWilliamson Gary · Ashmore, ILBuilt 1955 · S/N 22-3146 N2847ZRhodes Jacob H Jr · Lenoir, NCBuilt 1959 · S/N 22-6843 N2848PFreeman Joseph R · Lawrenceburg, TNBuilt 1955 · S/N 22-3148 N2848ZColumbus Sign Co Inc · Columbus, GABuilt 1959 · S/N 22-6844 N2849M49 Mike Partnership · Erie, COBuilt 1947 · S/N 12-1402 N2849ZAlexander Travis M · Weatherford, TXBuilt 1959 · S/N 22-6845 N284TWilliams David L · Shell Knob, MOS/N 18-2398 N2850MHarvey Timothy A · Colusa, CABuilt 1946 · S/N 12-1190 N2850PThomas Michael D · Dallas Center, IAS/N 22-3150 N2851PLaubscher William B · Farrandsville, PABuilt 1955 · S/N 22-3151 N2853MH&M Aviation · Hazelton, NDBuilt 1946 · S/N 12-1187 N2854DWilliams David O · Soldotna, AKBuilt 1952 · S/N 18-1275 N2854ZIntermountain Aviation LLC · Missoula, MTBuilt 1959 · S/N 22-6851 N2855TMcgregor Thomas M · Chugiak, AKBuilt 1959 · S/N 18-7071 N2856PHester Alan A · Battle Ground, WABuilt 1955 · S/N 22-3156 N2856ZCooksey Donald R · Newcastle, WYBuilt 1959 · S/N 22-6853 N2858PSiegfried Richard W · Downers Grove, ILBuilt 1955 · S/N 22-3159 N2858ZRoberts Darren T · Vail, AZBuilt 1959 · S/N 22-6855 N285HCStiller Mark R · Anchorage, AKBuilt 1960 · S/N 18-7464 N285TCooper John H III · Wasilla, AKBuilt 1953 · S/N 18-2399 N2860PSchwend Brian · Forsyth, MTBuilt 1955 · S/N 18-4447 N2860ZCarter Harold · Elizabethton, TNBuilt 1959 · S/N 22-6857 N2862MFrederick David · Juneau, AKBuilt 1946 · S/N 12-1285 N2863ZWhitaker Eric L · Detroit, TXS/N 22-6862 N2864ZUecker Todd M · Port Townsend, WABuilt 1959 · S/N 22-6871 N2865ZCrouder Trevor J · Fairbanks, AKBuilt 1959 · S/N 22-6864 N2868PRedman Adam J · Anchorage, AKS/N 18-4457 N2869PAlaska Aviation Museum · Anchorage, AKS/N 18-4459 N2869ZRolling Rock Equipment LLC · Mount Pleasant, PAS/N 22-6785 N286THenry James G · Bonita, CABuilt 1953 · S/N 18-2400 N2870MJohnson James F · Florence, MTBuilt 1946 · S/N 12-1199 N2870ZTracy Beverly E · Wray, COBuilt 1959 · S/N 18-7033 N2871PZweifel Douglas L · Anchorage, AKFirst renewal noticeBuilt 1955 · S/N 18-4461 N2873PCavanaugh Thomas Arthur · Gallatin Gateway, MTBuilt 1955 · S/N 18-4463 N2873ZLeroy Thomas A · Naples, FLBuilt 1959 · S/N 18-7036 N2874PCentral Air Svc Inc · Lewistown, MTBuilt 1955 · S/N 18-4464 N2875DMojica Waldemar · Arecibo, PRBuilt 1952 · S/N 18-1931 N2875MSzumal Brent · Wasilla, AKBuilt 1946 · S/N 12-1404 N2875PHandiboe Stephen J · Fort Lauderdale, FLBuilt 1955 · S/N 18-4467 N2876KNewhouse Hayden V · Fredericksburg, TXS/N 18-7039 N2876MJohnson William A · Dillingham, AKS/N 12-1304

Back to AD 99-01-05 R1