Registered aircraft · 85,633

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:98-21-21-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') 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:98-21-21-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
  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:98-21-21-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
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.

N1031RKeller Paul M · Sanford, NCBuilt 1989 · S/N 25-1216 N1031VIntelinair Geospatial LLC · Indianapolis, INBuilt 1974 · S/N U20602409 N1031WBilco Air LLC · Danville, ILBuilt 1973 · S/N E-403 N1032WOhlinger Mark A · Copley, OHBuilt 1973 · S/N D-9454 N1033PProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 23-35 N1033TManzo Deborah S · Lake Placid, FLBuilt 1973 · S/N 27-7405302 N1033WPunci Aviation II LLC · Port Washington, WIS/N D-9455 N1033XHorizon Enterprises LLC · Kalispel, MTBuilt 1975 · S/N 28-7515376 N1034XBlasa Randy · Bowling Green, FLS/N 28-7505198 N1035XSocal Blue Side Up LLC · Anaheim, CABuilt 1975 · S/N 28R-7535222 N1036LN1036l Corp · Wilmington, DEBuilt 1976 · S/N 27-7654135 N1036QKelley Michael · Bellingham, MABuilt 1977 · S/N 28-7716079 N1036TSlaughter Terry D · Perryton, TXBuilt 1976 · S/N E-928 N1036USandor Pethes · Terre Haute, INBuilt 1996 · S/N 24-3386 N1036XMotley Douglas Trustee · Rehoboth Beach, DEBuilt 1975 · S/N 32-7540131 N1037BSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1957 · S/N D-5311 N1037TJohnson Shem E · Bonners Ferry, IDBuilt 1972 · S/N 18260859 N1037VPulse Jeremy D · Moore, MTBuilt 1968 · S/N 18051989 N1038FPetrick Dan A · Punta Gorda, FLBuilt 1969 · S/N 28-25552 N1038WMulrooney Brian P · Minnetonka, MNBuilt 1981 · S/N 24-1118 N1039A39a LLC · Sioux Falls, SDS/N D-9009 N1039BG & M Aviation LLC · Kokomo, INBuilt 1981 · S/N 24-1119 N1039GFountain Keith E · Jacksonville, NCBuilt 1979 · S/N 21063174 N1039KMorris Eric K · Strasburg, VAS/N 24-3110 N1039TJera · Johnson City, TNBuilt 1977 · S/N E-1059 N1039UIowa Lakes Community College · Estherville, IABuilt 1971 · S/N 34-7250024 N1039XSilvered Wings LLC · Howell, MIBuilt 1975 · S/N 28-7525265 N103AMN103am LLC · Chehalis, WABuilt 1974 · S/N 18502615 N103ASHill Bryan Thomas · Page, AZBuilt 1979 · S/N R18200923 N103ATWjm Aviation LLC · Bridgeville, PABuilt 1970 · S/N 32-40951 N103AVFlying To Infinity And Beyond LLC · Atlanta, GABuilt 1983 · S/N 28-8390084 N103BMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 44-8107007 N103BUColorado Aircraft Corp · Watkins, COS/N 31-7405202 N103CCWhatley Wesley E · Plano, TXBuilt 1979 · S/N 28R-7918055 N103CTSocolosky Stephen Gerard · East Hartford, CTBuilt 1973 · S/N 17253365 N103DLDunwoody Duane E D · Savage, MNS/N 55913 N103DTPrescott Stephen I · Cornish, MES/N 320B0004 N103EAJwp Group LLC · Long Island, MEBuilt 1976 · S/N 32R7780054 N103EMSjm Aero LLC · Winter Haven, FLS/N 310R0083 N103EYSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 1150 N103FSHannah Lonnie · Williamson, WVBuilt 1979 · S/N 310R1834 N103GLNaylor Aviation LLC · Columbia, MOBuilt 1978 · S/N 31-7912023 N103HPMcfarland Natalie · Roseburg, ORBuilt 1965 · S/N 24-4153 N103JKWise Charlie S · Norfolk, VABuilt 1974 · S/N 28-7415271 N103KCLang Elmer N · Hemphill, TXBuilt 1979 · S/N 28-7911238 N103LHKavalair LLC Series D · Marion, MTBuilt 1980 · S/N TH-1170 N103PBBentley Jeffrey W · Kenmore, WABuilt 1957 · S/N 34372 N103PGHnd Operations LLC · Henderson, NVBuilt 1969 · S/N 30-1858 N103PTAvion Guy LLC · Baton Rouge, LABuilt 1975 · S/N 22-1252 N103RAArizone Game And Fish Dept · Phoenix, AZS/N U20605995

Back to AD 98-21-21 R1