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.

N7228JRedhanded LLC · Dover, DEBuilt 1968 · S/N 28-24564 N7229JLivingston Corey · Myrtle Beach, SCBuilt 1968 · S/N 28-24565 N7229WRoll The Bones LLC · Kiln, MSBuilt 1963 · S/N 28-1046 N722AKInternational Air Services Inc Trustee · Carson City, NVBuilt 1992 · S/N 2890172 N722AVMcdaniel Ibarra Professional Services Inc · Palm Desert, CABuilt 1976 · S/N 32R-7780029 N722FLShaughnessy Thomas E · Seabrook, NHS/N 28-7225404 N722GTable For Seven Aviation LLC · Mountain Brk, ALBuilt 1997 · S/N 3246066 N722NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881310 N722RMFisher Mark A · Leola, PABuilt 1974 · S/N 32-7440140 N722TCSchmitz William C · Charleston, SCBuilt 1978 · S/N 28-7990127 N722WMPegasus Enterprises LLC · Granbury, TXS/N 28R-7435045 N7230FBenautics LLC · Wexford, PABuilt 1968 · S/N 28-25143 N7230JBrewer Michael S · New Haven, WVBuilt 1968 · S/N 28-24566 N7231JMcflight Aviation LLC · Highland, UTBuilt 1968 · S/N 28-24567 N7232CVector Aviation LLC · Mentor, OHBuilt 1976 · S/N 28-7690061 N7232JEllero John L · Sun City, CABuilt 1968 · S/N 28-24568 N7232WAwmr LLC · Conroe, TXBuilt 1963 · S/N 28-1050 N7233JPinnick Andrew · Beckley, WVBuilt 1968 · S/N 28-24570 N7234CConfidential LLC · Lutz, FLBuilt 1975 · S/N 32R-7680043 N7234FBrinker Joe E · Little Hocking, OHBuilt 1976 · S/N 28-7715203 N7234WMoco Aviation LLC · Moultonborough, NHBuilt 1963 · S/N 28-1053 N7235WMorris George · Redlands, CABuilt 1963 · S/N 28-1054 N7236FRegistered aircraftBuilt 1968 · S/N 28-25148 N7236JBackman Randy L · Bellingham, WAS/N 28-24573 N7236UWuhu Industries LLC · Canby, ORS/N 32R-7780298 N7237WPetropulos James J · Juneau, AKBuilt 1963 · S/N 28-1056 N72383Niagarawings Aviation LLC · Niagara Falls, NYBuilt 1977 · S/N 28-7890141 N7238FDoll William J · Carlisle, PABuilt 1968 · S/N 28-25150 N7238WRupert Shon D · Greenwood, ARBuilt 1963 · S/N 28-1057 N7239WWiza Jason · Custer, WIBuilt 1963 · S/N 28-1059 N723AJCavorite Aviation LLC · West Jordan, UTBuilt 2005 · S/N 2843613 N723CFCay Air Inc · Largo, FLBuilt 1977 · S/N 32R-7780508 N723PC43rd Aviation Flying Club Inc · Norfolk, CTFirst renewal noticeBuilt 1998 · S/N 2843194 N723PMCeu LLC · Greer, SCBuilt 1967 · S/N 28-4329 N7240FDewberry Dylan C · Springfield, ORBuilt 1968 · S/N 28-25153 N7240JFlytt LLC · Naples, FLBuilt 1968 · S/N 28-24577 N7241CHeritage Timothy D · Glendale, AZBuilt 1975 · S/N 28-7625073 N7241JHopkins Justin C · Benson, AZFirst renewal noticeS/N 28-24578 N7241WBurtchett Tyler D · Buckeye, AZBuilt 1963 · S/N 28-1075 N7242FDjair · Winchester, VAS/N 28-25155 N7242WSouthwest Fluid Products Inc · Weatherford, TXS/N 28-1065 N7243FBlack Diamond Real Estate · Roseville, CABuilt 1968 · S/N 28-25159 N7243JNova Flight LLC · Gainesville, VABuilt 1968 · S/N 28-24583 N7243WLejeune Ovey Eugene · Roanoke Rapids, NCBuilt 1963 · S/N 28-1066 N7245FLeinart Brannon B · Merit, TXBuilt 1968 · S/N 28-25161 N7245JKallen David A · Northville, NYBuilt 1968 · S/N 28-24586 N7246CValiair Limited Co Trustee · Casper, WYBuilt 1975 · S/N 28-7615048 N7246JCooper Christopher B · Crowley, TXBuilt 1968 · S/N 28-24587 N7249FAndrews Josh S · Warsaw, MOBuilt 1968 · S/N 28-25166 N7249JJohnson Dale F · Marion, INBuilt 1968 · S/N 28-24591

Back to AD 87-08-08 R3