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.

N3670LLatch Leo D · Upland, CABuilt 1965 · S/N 17253839 N3671LCalmet Aircraft Leasing LLC · Middletown, DEBuilt 1965 · S/N 17253840 N3672GAcosta De La Torre Armando A · El Paso, TXS/N 29549 N3672LJanowski Stephen J Jr · Wadsworth, OHBuilt 1965 · S/N 17253841 N3673SMike Whiskey LLC · Le Claire, IABuilt 1963 · S/N 17250873 N3674SWiegand Gary E · Carmel Valley, CABuilt 1963 · S/N 17250874 N3675LSheppard Dale A · Kalispell, MTBuilt 1965 · S/N 17253844 N3677LBell Ellis E · Forrest City, ARBuilt 1965 · S/N 17253846 N3678RCarl Aviation LLC · Lake Havasu City, AZBuilt 1964 · S/N 17251566 N3678SMartone Douglas K · Windham, CTBuilt 1963 · S/N 17250878 N367CTCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10711 N367MAMindy Limited LLC · Muscatine, IABuilt 1998 · S/N 17280649 N367TWTextron Aviation Inc · Wichita, KSS/N 172S13607 N3680SLubonovic Thomas M · New Carlisle, OHBuilt 1963 · S/N 17250880 N3681LBurton Walter E · Statesboro, GABuilt 1965 · S/N 17253850 N3682LRiseaero LLC · Florence, SCBuilt 1965 · S/N 17253851 N3682SPederstuen Ricky L · Hudson, WIBuilt 1963 · S/N 17250882 N3685LBarber Richard S · Baker, NVBuilt 1965 · S/N 17253854 N3685SGarrison Randy L · Queen City, TXBuilt 1963 · S/N 17250885 N3686SBurg David J · Oroville, CABuilt 1963 · S/N 17250886 N3688LNamassivaya Nagaraju · Rexford, NYBuilt 1965 · S/N 17253857 N368ESMindy Limited LLC · Muscatine, IABuilt 1997 · S/N 17280022 N3690LSmith Steve J · Magnolia, TXBuilt 1965 · S/N 17253859 N3691SBogan Jeremy · Rusk, TXS/N 17250891 N3692SBrown Wesley B · Sparks, NVBuilt 1963 · S/N 17250892 N3693SChianese Anthony · Wylie, TXBuilt 1963 · S/N 17250893 N3694SJstream Lc · Sheridan, WYBuilt 1963 · S/N 17250894 N3695SZavada Michael S · Morris, MNBuilt 1963 · S/N 17250895 N3697LShearair LLC · Valparaiso, INS/N 17253866 N3697SRossi Michael · Big Pine, CABuilt 1963 · S/N 17250897 N369ADManston Quinton A · White, GABuilt 1977 · S/N 17269479 N369CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12346 N369DADuan Ran · Bothell, WABuilt 2023 · S/N 172S13041 N369ERTower Aviation Management LLC · Decatur, TXFirst renewal noticeS/N 172RG0062 N369NEPeter Travis E · Evansville, WYBuilt 1979 · S/N 172RG0233 N369PPPositive Attitude Ia LLC · Gaithersburg, MDBuilt 1974 · S/N 17263099 N369RAShaffer Patricia G · Texarkana, TXBuilt 1971 · S/N 17259719 N369RJD & S Aviation LLC · Spring, TXBuilt 1979 · S/N 17273068 N369SPXin Han Aviation LLC · Helena, MTS/N 17262809 N369TWChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9063 N36DSUp And Up Aviation LLC · Spring, TXBuilt 1970 · S/N 17259145 N36GRRiethof George N · Nantucket, MABuilt 1978 · S/N 17272026 N36JCSafety In Motion Flight Center Inc · Puyallup, WABuilt 1973 · S/N 17261759 N36JRCatching Freedom LLC · Bozeman, MTS/N 172S11204 N36JWBarr Air Patrol LLC · Mesquite, TXBuilt 1975 · S/N 17265589 N36SKFortin Jean T · Mechanicville, NYBuilt 1963 · S/N 17250459 N36ZQNorthern Flights LLC · Calumet, MIBuilt 1975 · S/N 17265019 N3700SMusket Air LLC · Page, AZBuilt 1963 · S/N 17250900 N3701LRice Solutions LLC · Plymouth, NHS/N 17253870 N3702LBailey April O · Papillion, NEFirst renewal noticeS/N 17253871

Back to AD 90-06-03 R1