Skip to content

Registered aircraft · 54,017

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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N46019La Porte Aero Club Inc · La Porte, INS/N 17256992 N4601BArnavair LLC · Pearland, TXBuilt 1955 · S/N 31499 N4601ETen Two Holdings LLC · Somers, MTBuilt 1982 · S/N 18268248 N4601GResicum International LLC · Gulf Shores, ALBuilt 1979 · S/N 17273270 N4601RMiddle Tennessee State University · Murfreesboro, TNS/N 172RG0003 N4601UChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1983 · S/N 21064790 N4601VDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1980 · S/N 172RG0336 N4601WMike Papa LLC · Newton, KSBuilt 1980 · S/N P21000622 N4601XMast Aviation LLC · South Boston, VABuilt 1966 · S/N 15064651 N46020Registration Pending · Brooksville, FLRegistration pendingBuilt 1978 · S/N 15282984 N46021152 4 Fun LLC · Gilbert, SCBuilt 1978 · S/N 15282985 N46024Garfield Joshua E · Tampa, FLBuilt 1968 · S/N 17256995 N46027Cleary Thomas J · Fairport, NYBuilt 1968 · S/N 17256997 N46028First Take Aviation LLC · Van Nuys, CABuilt 1968 · S/N 17256998 N4602SKeniston Kimberly A · Tyngsboro, MABuilt 1979 · S/N R18201353 N4602WBrugueras Ralph Steven · Deer Park, WABuilt 1963 · S/N 18254662 N46030Constance Air LLC · Luthersville, GABuilt 1968 · S/N 17257000 N46031Soucy Gary J · Brewer, MEBuilt 1968 · S/N 17257001 N46034Employment Services Inc · Virginia Beach, VABuilt 1978 · S/N 15282986 N4603BMonroe Frank B · Reno, NVBuilt 1955 · S/N 31501 N4603CMeyerhofer Richard A · Wasilla, AKBuilt 1953 · S/N 25547 N46047Loudermilk John A · Nashville, TNBuilt 1968 · S/N 17257010 N4604CRacoon Aviation LLC · San Antonio, TXBuilt 1953 · S/N 25548 N4604QBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 21059504 N4604VRogers Ann M · Traverse City, MIS/N 172RG0337 N46054Cabirdassou Meena · Arcadia, CABuilt 1968 · S/N 17257015 N46057Flight Time Builders Inc · Memphis, TNBuilt 1968 · S/N 17257018 N4605CMinder Gary L · Lincoln, ILBuilt 1953 · S/N 25549 N4605FSterling Aviation2 Lllc · Boca Raton, FLBuilt 1966 · S/N P206-0205 N4605QRichs Air Service · Victoria, KSBuilt 1971 · S/N 21059505 N4605UAir Dusters Inc · Roggen, COBuilt 1963 · S/N 18051305 N46060Registration Pending · Factoryville, PARegistration pendingBuilt 1968 · S/N 17257019 N46063Low Thomas A Trustee · Derry, NHBuilt 1973 · S/N 18052395 N4606XThird Coast Aircraft LLC · Mobile, ALBuilt 1966 · S/N 15064656 N46072Fly Anytime LLC · Kankakee, ILBuilt 1968 · S/N 17257025 N46075Perspective Aviation LLC · Comer, GABuilt 1978 · S/N 15282995 N46078Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1968 · S/N 17257030 N4607F7 Fox LLC · Eugene, ORBuilt 1966 · S/N P206-0207 N4607QSerrano Lynn A · Casa Grande, AZBuilt 1971 · S/N 21059507 N4607UBlack Spruce Aviation LLC · Hermon, MES/N 30251 N4607XVeldhuizen Richard B · Jesup, GABuilt 1966 · S/N 15064657 N46080Sentinel Services Group LLC · Brooksville, FLBuilt 1978 · S/N 15282227 N46085Davenport Jimmy J · Hayesville, NCBuilt 1974 · S/N 17264175 N46087Range Steven V · Greenfield, ILBuilt 1968 · S/N 17257034 N4608CTrinity Property Management LLC · Corvallis, ORS/N 21063572 N4608FAdvanced Aerospace Consultants Inc · Boynton Beach, FLBuilt 1966 · S/N P206-0208 N46090Sentinel Services Group LLC · Brooksville, FLBuilt 1981 · S/N 15285318 N46091Pilot Instructional Center LLC · Kansas City, MOBuilt 1974 · S/N 17264176 N46092Breithaupt Tracy L · Alexandria, LAS/N 17257038 N4609LStork 1 LLC · Green Cove Springs, FLBuilt 1980 · S/N 15284197

Back to AD 87-20-03 R2