Skip to content

Registered aircraft · 22,416

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N8011WByrd John C · Garland, TXBuilt 1964 · S/N 28-2074 N8012NRegistration Pending · Alexandria, VARegistration pendingBuilt 1969 · S/N 28-25253 N8012WDe Torres Thomas · Fithian, ILFirst renewal noticeBuilt 1964 · S/N 28-2075 N8013FCooke Douglas L · Ventura, CABuilt 1976 · S/N 28-7715252 N8013NDowns Michael M · Sarasota, FLBuilt 1968 · S/N 28-25255 N8013WFergus Greg S · Frisco, TXBuilt 1964 · S/N 28-2076 N8014NLambert Daniel V · Mosheim, TNBuilt 1968 · S/N 28-25256 N8015NPatton Aviation LLC · Billings, MTBuilt 1968 · S/N 28-25257 N8015WRayferd Air LLC · Douglas, GABuilt 1964 · S/N 28-2078 N80161Redlin Thomas J · Sioux Falls, SDBuilt 1969 · S/N 28-25259 N8018CPatterson Charles A · Springfield, OHBuilt 1975 · S/N 32-7600008 N8018NMacris Troy C · Tarpon Springs, FLBuilt 1981 · S/N 28-8216082 N8018WBloser Austin P · Adel, GAS/N 28-2083 N8019VJuliet One LLC · Newark, DEBuilt 1981 · S/N 28-8290074 N8019WJeffs Free-1 To Fly LLC · Pennsburg, PABuilt 1964 · S/N 28-2084 N801APAviation 4 US Inc · Brooklyn, NYBuilt 1976 · S/N 28-7615168 N801FCN801fc LLC · Belle Chasse, LABuilt 1980 · S/N 28-8016285 N801FSRenfro Michael W · Bethel, AKBuilt 1970 · S/N 28-7125090 N801GAOn 2 Abaco LLC · Leesburg, FLBuilt 1998 · S/N 3246107 N801MTAshland Aviation LLC · Ashland, OHBuilt 1983 · S/N 32-8306030 N8020FAdams Blaine M · Litchfield, MNBuilt 1976 · S/N 28-7715253 N8021NThibodeaux Bert J · Cedar Rapids, IABuilt 1968 · S/N 28-25264 N8021ULundell Brad · Kiron, IABuilt 1981 · S/N 28-8211020 N8022NNiendorf John R · Friday Harbor, WABuilt 1968 · S/N 28-25265 N8022WDean Newton Aviation LLC · Whitehouse Station, NJBuilt 1964 · S/N 28-2087 N8023LSound Air LLC · Easton, CTBuilt 1982 · S/N 32R-8213018 N8023NStafford Craig A · Tempe, AZBuilt 1968 · S/N 28-25267 N8023WHydroplane Ltd · Sherman Oaks, CABuilt 1965 · S/N 28-2918 N8024AJakubik Joshua D · Magnolia, TXS/N 32R-8313008 N8024DAbcon Automation Inc · Harrison, OHS/N 32R-8213004 N8024NAll American Aviation Services Inc · Fayetteville, NCBuilt 1968 · S/N 28-25268 N8024YValiair Lc Trustee · Casper, WYBuilt 1981 · S/N 32R-8229018 N8025N8025n Flyers Ltd · Monsey, NYBuilt 1968 · S/N 28-25269 N8025WMann Nicholas Lee · Grand Canyon, AZBuilt 1964 · S/N 28-2090 N8026NJenkins Carl S · Muncy, PABuilt 1968 · S/N 28-25270 N8027FCyganski David · Palm Beach Gardens, FLBuilt 1976 · S/N 28-7715255 N8029NHeydenreich Jacob N · Hartford, ARBuilt 1968 · S/N 28-25274 N802CMN802cm LLC · Lebanon, MOBuilt 2002 · S/N 2843541 N802FSShelton Shannon · Hampton, GABuilt 1971 · S/N 28-7125398 N802RCCollum Aviation LLC · Milton, FLBuilt 1967 · S/N 28R-30299 N802UMLawrence Dayle A · Scotia, CABuilt 1972 · S/N 28-7225524 N8030NWilson Mark A · Havana, FLBuilt 1968 · S/N 28-25275 N8030WGosse Luke J · Waterloo, IABuilt 1964 · S/N 28-2096 N8031WGraziano Michael A · Freeport, NYBuilt 1965 · S/N 28-2097 N8032CAirwego LLC · Wilmington, DEBuilt 1975 · S/N 28-7690097 N80339Green Robert H · Lakewood, CABuilt 1981 · S/N 28R-8231019 N8033WRegistration Pending · Burlington, WARegistration pendingBuilt 1965 · S/N 28-2099 N80349Giles Jonathan P · Fountain Inn, SCBuilt 1981 · S/N 32R-8213020 N8034NKoehler Gerry P · Harbor City, CABuilt 1968 · S/N 28-25279 N8034WFieldgrove Kevin · Monroe, GABuilt 1965 · S/N 28-2101

Back to AD 87-08-08 R3