Skip to content

Registered aircraft · 2,552

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:76-08-02-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-08-02-R2') 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:76-08-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-08-02-R2')
  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:76-08-02-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-08-02-R2')
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.

N320TJBlaylock Arthur S III · Pace, FLBuilt 1963 · S/N 320B0017 N320TTCarroll Richard J · Pocatello, IDBuilt 1966 · S/N 320E-0081 N320VCDelta Three Air Services Inc · Burton, OHBuilt 1966 · S/N 320E-0016 N321BURegistration Pending · Tavares, FLRegistration pendingBuilt 1966 · S/N 310K0184 N321DWJsj LLC · Wilmington, DEBuilt 1979 · S/N 310R1823 N321HDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 414-0625 N321HASkytook LLC · Wilmington, DEBuilt 1973 · S/N 421B0420 N321RPIsrael Oscar M III · Sinton, TXBuilt 1973 · S/N 340-0201 N3227ABoho LLC · Lewes, DEBuilt 1980 · S/N 310R1881 N322CCoffman Robert P · Bigfork, MTS/N 320C0073 N3239Q92nd West Aviation Inc · Lonoke, ARBuilt 1967 · S/N 401-0039 N3257XN1002q LLC · Lake Butler, FLBuilt 1967 · S/N 310L-0107 N3258XWrenn William H · Baytown, TXS/N 310L-0108 N3264QWilton William H · Kailua Kona, HIBuilt 1967 · S/N 401-0064 N3264XDesert Cat Aviation LLC · Tempe, AZBuilt 1967 · S/N 310L-0114 N3266XRegistered aircraftBuilt 1967 · S/N 310L-0116 N3268QSuperior Food Distributors LLC · Naples, FLBuilt 1967 · S/N 401-0068 N326PTJt Aero LLC · Covington, GABuilt 1974 · S/N 310Q0968 N3271XCoastal Defense Inc · Mill Hall, PABuilt 1967 · S/N 310L-0121 N3274XBoyer Dennis A · Harvest, ALBuilt 1967 · S/N 310L-0124 N3279MValiair Limited Co Trustee · Casper, WYBuilt 1980 · S/N 310R1891 N3280XCoastal Defense Inc · Mill Hall, PABuilt 1967 · S/N 310L-0130 N3284MSonrise Aviation LLC · Portland, INS/N 310R1892 N3288MClute Kenneth N · Las Vegas, NVBuilt 1980 · S/N 310R1895 N3290XBirman Pablo E · Suamico, WIBuilt 1967 · S/N 310L-0140 N32TLJonesboro Cycle And Atv LLC · Bone, ARBuilt 1974 · S/N 310R0032 N32VSCraftline LLC · Delray Beach, FLS/N 340-0025 N3304QMcnutt Brian K · Mojave, CAS/N 320D0104 N3304XPhillips Daniel J · Argusville, NDBuilt 1967 · S/N 310L-0154 N3307XMathison John M · Vancouver, WABuilt 1967 · S/N 310L-0157 N3308QDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 320D0108 N3309QB & R Aerial Crop Care Inc · Connell, WABuilt 1966 · S/N 320D0109 N3309XCabanas Alexis Santiago · Stroudsburg, PAS/N 310L-0159 N3310DGrewe Mike · Lake In The Hills, ILBuilt 1972 · S/N 310Q-0630 N3313XBowman Cody · Brooklyn, MIBuilt 1967 · S/N 310L-0163 N3314XGalloway James D · Whitmore Lake, MIS/N 310L0164 N3315QTcf Ventures LLC · Wilmington, DEBuilt 1966 · S/N 320D0115 N3315XElberg Paul · Aventura, FLBuilt 1967 · S/N 310L0165 N3316QPerson Michael · West Chester, PABuilt 1966 · S/N 320D0116 N3317QSkynight 17q LLC · Roseville, CABuilt 1966 · S/N 320D0117 N3318Q2400 Rickenbacker LLC DBA · Auburn, CABuilt 1966 · S/N 320D0118 N3319QNeuschaefer George H · White Hills, AZBuilt 1966 · S/N 320D0119 N331BXFay Craig J · Fairfax Station, VABuilt 1967 · S/N 310L-0168 N331LSTechnical Education Services Inc · Virginia Beach, VABuilt 1969 · S/N 310Q0028 N331TCOn Trend Homes LLC · Columbia, MOS/N 414-0943 N3321MMaxray Aviation LLC · Ashland, OHBuilt 1978 · S/N 310R1343 N3321XPatton Aviation LLC · Billings, MTS/N 310L-0171 N3322XAllgood Michael K · Saint Augustine, FLBuilt 1974 · S/N 310Q1030 N3325QWinrick LLC · Flagstaff, AZS/N 320D0125 N3327XTrimble Anthony W · Weatherford, TXBuilt 1967 · S/N 310L-0177

Back to AD 76-08-02 R2