Skip to content

Registered aircraft · 54,015

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.

N8210MPeavy Magnus Delacy IV · Crawfordville, FLBuilt 1969 · S/N 21059210 N8211BHayfield Technical Services LLC · Tahlequah, OKS/N 36011 N8211GSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1971 · S/N 177RG0111 N8211LWelch James J · Salisbury, NCBuilt 1967 · S/N 17256411 N8212AScarboro Thomas E · North Pole, AKBuilt 1952 · S/N 25064 N8212BSeven Delta Whiskey Club · Brush Prairie, WABuilt 1957 · S/N 36012 N8212GDavis Richard M · Southport, NCBuilt 1971 · S/N 177RG0112 N8212LVersaw Charles J · Center, COBuilt 1967 · S/N 17256412 N8212XMonahan Linda J · Groveland, CABuilt 1961 · S/N 17248712 N8212ZJms Aviation LLC · Waynesville, OHS/N 205-0212 N8213LTraining Planes LLC · Tampa, FLBuilt 1967 · S/N 17256413 N8213SMcilrath Paul J · Des Moines, IABuilt 1965 · S/N 15061813 N8213TMortenson Jay E · Venice, CABuilt 1960 · S/N 17556913 N8213UJohnson Matthew K · Paducah, KYBuilt 1964 · S/N 17252113 N8213VRiver City Real Estate LLC · Otis, MEBuilt 1966 · S/N 18051715 N82149Sanders Flight Training Center Inc · Jasper, ALBuilt 1976 · S/N 17267692 N8214ARozycki Seth · Little Falls, MNBuilt 1952 · S/N 25066 N8214FHoneycutt David · Columbus, MSBuilt 1966 · S/N 15064314 N8214GKolman Michael D · Overland Park, KSBuilt 1971 · S/N 177RG0114 N8214UN8214u LLC · Sheridan, ARBuilt 1964 · S/N 17252114 N8214XStroemsvik Kristian · Strasburg, VABuilt 1961 · S/N 17248714 N8215GGersten Iron · Spring Valley, CABuilt 1971 · S/N 177RG0115 N8215LUmphrey Reid · Douglasville, GABuilt 1967 · S/N 17256415 N8215XLaforest Jerome P · White Lake, MIBuilt 1961 · S/N 17248715 N8215ZRg Aviation Inc · Wilmington, DEBuilt 1962 · S/N 205-0215 N8216ADates Lauren C · Red Creek, NYBuilt 1952 · S/N 25068 N8216BBrezina Chad M · Whitewright, TXBuilt 1957 · S/N 36016 N8216GFarrar Edwin L · Mansfield, OHBuilt 1971 · S/N 177RG0116 N8216JGuth Martin H · Kasilof, AKFirst renewal noticeBuilt 1976 · S/N 18502864 N8216LWoodworth Mark S · Madison, OHBuilt 1967 · S/N 17256416 N8216UClinch Jerome J · Lincoln, NEBuilt 1964 · S/N 17252116 N8216XRiver Town Aviation LLC · Williamstown, WVS/N 17248716 N8217BRoll George N · Freeport, FLBuilt 1957 · S/N 36017 N8217GVne Aviation LLC · Dripping Springs, TXBuilt 1974 · S/N 18263352 N8217LSteward Kim R · Durand, ILBuilt 1967 · S/N 17256417 N8217MBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 18264566 N8217XRiggs John · Punta Gorda, FLBuilt 1961 · S/N 17248717 N8218FDel Rosario Jose · Hackettstown, NJBuilt 1966 · S/N 15064318 N8218LTufts Kyle J · Hampden, MEBuilt 1967 · S/N 17256418 N8218USalley Ronald C · Satellite Beach, FLBuilt 1964 · S/N 17252118 N8218XEvans James · Millbrae, CAS/N 17248718 N8219AElder Joel M · Scott City, KSBuilt 1952 · S/N 25071 N8219FKietzer Tyler L · Mankato, MNS/N 15064319 N8219GSchaum Jerome B · Machipongo, VABuilt 1971 · S/N 177RG0119 N8219MFair Winds Group LLC · Portage, MIBuilt 1969 · S/N 21059219 N8219UShaffer Kenneth H · Trout Lake, WABuilt 1964 · S/N 17252119 N8219VGreenman Lisa J · Chesterton, INBuilt 1956 · S/N 29884 N8219XCouch James T · Choctaw, OKBuilt 1961 · S/N 17248719 N821HGGeorgia Aviation Authority · Eastman, GABuilt 1978 · S/N 18266354 N821RMC&C Aero LLC · Billings, MTBuilt 1967 · S/N 17256414

Back to AD 87-20-03 R2