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.

N63014Taylor Daniel S · The Woodlands, TXBuilt 1981 · S/N 17275374 N63017Adams Aviation Services Inc Trustee · Wilmington, DEBuilt 1981 · S/N 17275377 N63019Althaver David B · Kearny, NJBuilt 1981 · S/N 17275379 N6301AJohnson James A · Fairbanks, AKBuilt 1956 · S/N 33101 N6301DR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17272706 N6301EJc Air Academy Inc · Stockton, CAS/N 17272004 N6301LHarding Benjamin H Jr · Yadkinville, NCBuilt 1980 · S/N 15284384 N6301SAbercrombie Michael J · Eureka, CABuilt 1967 · S/N 15067101 N6302FForrest Steven L · Wrangell, AKBuilt 1967 · S/N 17255486 N63033Baumer Luke R · Pittsboro, INS/N 15077051 N63036Registered aircraftS/N 15077052 N6303BUpper Valley Aero LLC · Hanover, NHBuilt 1978 · S/N 21062741 N6303DKilbourn Stuart L · Hughesville, PABuilt 1948 · S/N 18015 N6303FCommercial Leasing Unlimited LLC · Mesa, AZBuilt 1975 · S/N 18264151 N6303TPink Pilot LLC · Madison, WIBuilt 1983 · S/N R18201965 N63040Bullington Michael D · Spring Hill, TNBuilt 1975 · S/N 15077056 N63042Ting Chih-Wei · Tracy, CABuilt 1975 · S/N 15077058 N63046Lindholm Michael D · Anchorage, AKS/N 15077060 N63047Ggf Inc · Jacksonville, ARS/N 15077061 N6304KMeadows Michael M · Cypress, TXBuilt 1976 · S/N R1722038 N6304MMls Aviation LLC · Yorba Linda, CABuilt 1980 · S/N 15284663 N6304SCowey Kevin M · Pittsburgh, PAS/N 15067104 N6304TOverseas Flyway LLC · Tavernier, FLBuilt 1983 · S/N R18201966 N6304UHutt Aviation Inc · Minden, NVBuilt 1985 · S/N 21064932 N63051Moss Ronald J · Hamer, IDBuilt 1975 · S/N 15077065 N63053Claeys John T · Blue Grass, IABuilt 1975 · S/N 15077066 N63057Guerra Enmanuel M · Weirsdale, FLBuilt 1975 · S/N 15077070 N6305AMissouri Aviation Inc · Leeton, MOBuilt 1956 · S/N 33105 N6305BLeggett Bryce · Eola, TXBuilt 1957 · S/N 34205 N6305FGianquinto Joseph J Trustee · Bakersfield, CABuilt 1975 · S/N 18264152 N6305SPrivette Hugh T Trustee · Colorado Springs, COS/N 15067105 N6305UMission Aviation Fellowship · Nampa, IDS/N U20605411 N63062Cade Richard G · Lopez Island, WABuilt 1975 · S/N 15077074 N63066Rench Eugene G · Owosso, MIBuilt 1975 · S/N 15077075 N6306BGmr Leasing LLC · Lincoln, DES/N 34206 N6306CLongs Air Conditioning Inc · Avon Park, FLBuilt 1980 · S/N 21063860 N6306FBaymax Aviation LLC · Ronkonkoma, NYS/N 17273186 N6306GMartin Robert · Sylvester, GABuilt 1970 · S/N 15071806 N63074Charlton Jeremiah · Rockford, ILBuilt 1975 · S/N 15077082 N63079Ark Aerospace LLC · Fort Walton Beach, FLBuilt 1975 · S/N 15077087 N6307BCarpenter Alan B · Wasilla, AKBuilt 1979 · S/N 18503742 N6307JMiloud Chadd · Fort Worth, TXBuilt 1980 · S/N 17273860 N6308ABravo Hotel LLC · Lewes, DEFirst renewal noticeBuilt 1956 · S/N 33108 N6308BSnyder Kenneth Clayton · Lonsdale, MNBuilt 1959 · S/N 34208 N6308GDreher Easton · Wis Dells, WIBuilt 1970 · S/N 15071808 N6308HAmerican Aviation Inc · Page, AZBuilt 1978 · S/N 20700476 N6308JKatuzienski Joseph C · Yorktown, VABuilt 1980 · S/N 17273861 N6308RIngalls Randy · Alexandria, LABuilt 1979 · S/N 172RG0159 N63091Hobbs Kole T · Greenville, TXBuilt 1975 · S/N 15077098 N63092Lozano Jorge L · Miami, FLS/N 15077099

Back to AD 87-20-03 R2