Skip to content

Registered aircraft · 8,921

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:85-02-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:85-02-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:85-02-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:85-02-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:85-02-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:85-02-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.

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 N2849ZAlexander Travis M · Weatherford, TXBuilt 1959 · S/N 22-6845 N2850PThomas Michael D · Dallas Center, IAS/N 22-3150 N2851PLaubscher William B · Farrandsville, PABuilt 1955 · S/N 22-3151 N2854ZIntermountain Aviation LLC · Missoula, MTBuilt 1959 · S/N 22-6851 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 N2860ZCarter Harold · Elizabethton, TNBuilt 1959 · S/N 22-6857 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 N2869ZRolling Rock Equipment LLC · Mount Pleasant, PAS/N 22-6785 N286DDKhag Aviation Inc · Woodbridge, NJFirst renewal noticeS/N 27-7854019 N286PASkywest Leasing Inc · St George, UTBuilt 2002 · S/N 4496109 N287GE7ge Aviation LLC · Southfield, MIFirst renewal noticeBuilt 1964 · S/N 30-522 N287PASkywest Leasing Inc · St George, UTBuilt 2002 · S/N 4496110 N2882CG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 44-7995302 N288ABSyrasoft Aviation LLC · Baldwinsville, NYBuilt 1962 · S/N 24-3033 N289WWVision Aircraft II LLC · Scottsdale, AZBuilt 1971 · S/N 39-84 N289ZZAero Mobil Inc · Wilmington, DEBuilt 1969 · S/N 39-88 N28WRN28wr LLC · Simpsonville, SCBuilt 1971 · S/N 27-4626 N2900PBurns Travis S · Central Point, ORBuilt 1955 · S/N 22-3163 N2900ZCheatham Paul · La Verne, CABuilt 1959 · S/N 22-6868 N2901ZSmith Roger L · Los Alamos, NMBuilt 1959 · S/N 22-6873 N2902PHentgen Chip · Peru, INBuilt 1955 · S/N 22-3168 N2904PRandall Airlines LLC · Wendell, NCBuilt 1965 · S/N 24-4191 N2905PSimpson Danny R · Waunakee, WIBuilt 1955 · S/N 22-3172 N2907PWickenheiser John D · Newport, MIBuilt 1955 · S/N 22-3175 N2908PHull Mahlon B · Sedro Woolley, WABuilt 1955 · S/N 22-3176 N290MSurging Skyward Inc · Newtown, PAS/N 27-7554111 N290NDChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 4496021 N290VGAlmy David W · Riverside, CAS/N 23-5 N2912PJackson Robert S · Gallatin, TNBuilt 1955 · S/N 22-3180 N2912ZFord Charles D · Clifton, TNBuilt 1959 · S/N 22-6882 N2913UAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N 44-8107057 N2914PPerreault Guy · Newbury Park, CABuilt 1955 · S/N 22-3182 N2914ZEarle Russell John · Reno, NVBuilt 1959 · S/N 22-6884 N2916WPilots Flying School LLC · Manalapan, NJBuilt 1979 · S/N 44-7995300 N2917PRegistered aircraftBuilt 1955 · S/N 22-3185 N2917ZRegistration Pending · Granby, MORegistration pendingBuilt 1959 · S/N 22-6887 N2918PLafferty Eric M · Anchorage, AKBuilt 1955 · S/N 22-3186 N2918ZLarson David R · Boerne, TXS/N 22-6888 N2919ZPankonin Steve B · White City, ORS/N 22-6889 N291VPSeacrest Enterprises LLC · Asheville, NCS/N 27-8154025 N2920PErwin Randall · Johnson City, TNBuilt 1955 · S/N 22-3188 N2920ZBruch Robert Allen · Roanoke, VABuilt 1959 · S/N 22-6890

Back to AD 85-02-05 R1