Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N2602UVan Zee Charles C · Rancho Cucamonga, CABuilt 1963 · S/N 17250202 N2603LMagel David J · Lakemoor, ILBuilt 1967 · S/N 17255803 N2604UTalboy Theodore Neal · Lathrop, CABuilt 1963 · S/N 17250204 N2609LHavertown Flyers LLC · Havertown, PABuilt 1967 · S/N 17255809 N260PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S11001 N260SUOhio State University · Columbus, OHBuilt 2018 · S/N 172S12160 N26110Career Track 5 LLC · Wilmington, DEBuilt 2026 · S/N 172S13560 N26111Career Track 5 LLC · Wilmington, DEBuilt 2026 · S/N 172S13563 N26112Career Track 5 LLC · Wilmington, DEBuilt 2026 · S/N 172S13566 N2612UNeu Aviation LLC · Benton, LABuilt 1963 · S/N 17250212 N26139Textron Aviation Inc · Wichita, KSS/N 172S13625 N2613LOzark Aviators Inc · Willow Springs, MOBuilt 1967 · S/N 17255813 N2613UHill Richard W · Salem, ORBuilt 1963 · S/N 17250213 N26140Textron Aviation Inc · Wichita, KSS/N 172S13628 N26143Textron Aviation Inc · Wichita, KSS/N 172S13631 N26145Textron Aviation Inc · Wichita, KSS/N 172S13634 N26146Textron Aviation Inc · Wichita, KSS/N 172S13637 N26148Textron Aviation Inc · Wichita, KSS/N 172S13640 N26149Textron Aviation Inc · Wichita, KSS/N 172S13643 N26150Textron Aviation Inc · Wichita, KSS/N 172S13646 N26153Textron Aviation Inc · Wichita, KSS/N 172S13649 N2617QKerhulas Anthony B · Santa Maria, CABuilt 1969 · S/N 17258707 N2618UOubari Hesham D · Suffolk, VABuilt 1963 · S/N 17250218 N2619UChase Joshua R · Princeton, MNBuilt 1963 · S/N 17250219 N261EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13501 N261JBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12575 N261SCIndia Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13439 N261SEGapen Patrice Marie · Cheyenne, WYBuilt 1962 · S/N 17249852 N2621LTailwinds Flying LLC · Cherokee Ridge, ALBuilt 1967 · S/N 17255821 N2621ZWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1998 · S/N 17280559 N2622UComos Gregg J · West Palm Beach, FLBuilt 1963 · S/N 17250222 N2623LAli Bryan N · Miami, FLBuilt 1967 · S/N 17255823 N2624UGillespie Richard L · Beaver Island, MIBuilt 1963 · S/N 17250224 N2625CL&W Leasing LLC · Murfreesboro, TNBuilt 1998 · S/N 17280436 N2625LYezarski Edward J · Shirley, NYBuilt 1967 · S/N 17255825 N2625URogers James F III · Dover, NHBuilt 1963 · S/N 17250225 N2626UFarren Jake J · Eagle River, AKBuilt 1963 · S/N 17250226 N2628LBerg C Aaron · Driscoll, NDS/N 17255828 N2628UMiranda Jason G · Utica, OHBuilt 1963 · S/N 17250228 N2629LHein Merilee K · Mabel, MNBuilt 1967 · S/N 17255829 N262EEHorizon Flights Corp · Henderson, NVBuilt 1973 · S/N 17261621 N262ERRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 17263854 N262MGordon Bruce · Marstons Mills, MABuilt 1976 · S/N 17268356 N2630MMock Air LLC · Marion, INBuilt 1979 · S/N 17271166 N2630UShaka Skies LLC · Kihei, HIBuilt 1998 · S/N 17280568 N2632LKelley James M · Greenwood, ARBuilt 1967 · S/N 17255832 N2632YAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280570 N2634EAzul Services LLC · Bozeman, MTBuilt 1998 · S/N 17280572 N2634LMetal Mistress Aviation LLC · Meadowview, VABuilt 1967 · S/N 17255834 N2634UCoolaire LLC · Boerne, TXBuilt 1963 · S/N 17250234

Back to AD 90-06-03 R1