Skip to content

Registered aircraft · 85,620

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.

N1340ZLogue Andrew Douglas Trustee · Port Saint Lucie, FLBuilt 1961 · S/N TD-474 N1341DBuilders Guild Inc · Mesa, AZBuilt 1951 · S/N 19917 N1341FDix Justin T · South Boston, VABuilt 1966 · S/N 17254836 N1341HAlseth Engineering LLC · Kirkwood, MOS/N 28-7790306 N1341TShuman Cecil R Trustee · Chugiak, AKBuilt 1972 · S/N 28R-7235264 N1341YLong Gary A · Lewisport, KYBuilt 1962 · S/N 17249041 N1341ZC A R Lease Corp Inc · Brentwood, TNBuilt 1961 · S/N TD-473 N13426Sardeson Ronald L · Greenwood, NEBuilt 1973 · S/N 17262744 N13429Mercado Carlos · San Juan, PRBuilt 1973 · S/N 17262746 N1342DCaso Joseph J · Amity Harbor, NYS/N 19918 N1342FFriedman Peter Michael · Pleasant Hill, CABuilt 1966 · S/N 17254837 N1342GSpector Steven D · Glenview, ILBuilt 1974 · S/N 310R0026 N1342HRobertson James P Trustee · Templeton, CABuilt 1977 · S/N 28-7790307 N1342SFreeworld Aviation LLC · Dixon, ILBuilt 1976 · S/N 18264905 N1342TCrewdawg Aviation LLC · Concord, NCBuilt 1972 · S/N 28R-7235265 N13431Kelly William W · Springfield, ORBuilt 1973 · S/N 17262748 N13435Torres Debra A · El Paso, TXBuilt 1973 · S/N 17262749 N13437Dyberg Michael DBA · Mount Vernon, WABuilt 1973 · S/N 17262751 N1343DHaanen Jeffrey J · Browns Valley, MNBuilt 1951 · S/N 19919 N1343SComalander Christopher R · Beaumont, TXBuilt 1976 · S/N 18264906 N1343TWestern Cherokee Six LLC · Fort Collins, COBuilt 1972 · S/N 32-7240114 N1343WInfinity Aviation LLC · Piedmont, SDBuilt 1964 · S/N 2693 N1343ZBriscoe Travis L · Archie, MOS/N D-6770 N13445Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1973 · S/N 17262756 N13447Vessichelli Ryan A · Virginia Beach, VABuilt 1973 · S/N 17262757 N1344DWolf Ronald T · Abbeville, LABuilt 1951 · S/N 19920 N1344HConner W Larry · Los Lunas, NMBuilt 1977 · S/N 28-7790308 N1344PCrist Charles E · Waxahachie, TXBuilt 1955 · S/N 23-390 N1344UGrit Services LLC · Manila, ARBuilt 1962 · S/N 18254544 N1344WVortex Aviation LLC · Biloxi, MSS/N 2625 N13450Wilkes Flying Club Inc · Wilkesboro, NCBuilt 1973 · S/N 17262760 N13451Kostman Cody J · Bingham, NEBuilt 1973 · S/N 17262761 N13452Butler Shane M · Russellville, ARBuilt 1973 · S/N 17262762 N13456Johnson Richard A · Chandler, AZBuilt 1973 · S/N 17262766 N1345DBraner Richard C Trustee · Oakdale, CABuilt 1951 · S/N 19921 N1345SGrant Larry · Sebring, FLBuilt 1976 · S/N 18264908 N1345WHendricks John E · Heber Springs, ARBuilt 1963 · S/N 2626 N1345YFlying Horse LLC · Missoula, MTBuilt 1961 · S/N 17249045 N13460Robinson Doyle K · Panhandle, TXS/N 17262767 N13461Aero Maintenance Inc · Vancouver, WABuilt 1973 · S/N 17262768 N13464Seal Charles Kevin · Luray, VABuilt 1973 · S/N 17262770 N13465Mach III Flying Inc · Platte City, MOBuilt 1973 · S/N 17262771 N13469Angels Over Atlanta Inc · Fayetteville, GABuilt 1973 · S/N 17262773 N1346EMonillas Peter C · Martinez, CABuilt 1978 · S/N 17270964 N1346GClear Blue Aviation LLC · Melbourne, FLBuilt 1974 · S/N 310R0029 N1346TNortham Thaddeus R · Mckinney, TXS/N 28-7205284 N1346WUnal Alper Cevat · Las Vegas, NVBuilt 1963 · S/N 2627 N13475Wisk Aero LLC · Mountain View, CABuilt 1973 · S/N 17262778 N13479Hendricks Field Aviation LLC · Sebring, FLBuilt 1973 · S/N 17262781 N1347FSprague Lee G · Augusta, GABuilt 1966 · S/N 17254842

Back to AD 98-21-21 R1