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.

N2221RPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1998 · S/N 17280681 N22230Paulsen Bryant A · Lynden, WABuilt 1974 · S/N 17264059 N22237Aviation Training LLC · Wilmington, DEBuilt 2005 · S/N 172S10025 N2225AFreedom Aviation Inc · Lynchburg, VABuilt 2007 · S/N 172S10467 N2225FTextron Aviation Inc · Wichita, KSBuilt 2007 · S/N 172S10468 N22265Edb Air Inc · Wilsonville, ORBuilt 2005 · S/N 172S10026 N22271Ps N22271 LLC · Green Bay, WIBuilt 1974 · S/N 17264061 N2229ESix Pack Aviation LLC · Pocono Pines, PABuilt 1978 · S/N 17271193 N222BKDeralex Airways LLC · Miami, FLS/N 17272887 N222BVBb Air LLC · Chesapeake, VABuilt 1975 · S/N 17264997 N222DCTextron Aviation Inc · Wichita, KSS/N 18283364 N222HERound Engine Aero · Nashville, MIBuilt 1978 · S/N 17271191 N222LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2001 · S/N 172S8919 N222NYCivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276473 N222TXJ M Williams LLC · Stockton, CABuilt 1957 · S/N 29976 N222USTicoair LLC · Wilmington, DEBuilt 1979 · S/N 17273491 N2230WJac & Phill Corp · San Ysidro, CAS/N 17250077 N2232EPink Skies Inc · Willoughby, OHBuilt 1978 · S/N 17271195 N2235ELivingston Eric L DBA · Winchester, INBuilt 1978 · S/N 17271198 N2235VE & R Aviation Services Inc · Long Beach, CABuilt 2007 · S/N 172S10478 N2238EAtd Pilot Training LLC · Kansas City, MOS/N 17271199 N22395Morrison Donald D · Santa Clarita, CABuilt 1974 · S/N 17264063 N223APJuliet Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13440 N223BECampbell Edward A · Anchorage, AKBuilt 1977 · S/N 17268915 N223BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280950 N223CKBounds Keith A · Thomson, GABuilt 2004 · S/N 172S9580 N223HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 17281112 N223LPChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9223 N223TRTurner Lee W · Valdosta, GABuilt 1968 · S/N 17257757 N2240EKellogg Jeffrey D · Adams Center, NYBuilt 1978 · S/N 17271200 N2241VEdwards John D · Yardley, PABuilt 2007 · S/N 172S10481 N22429Johnson Dustin W · Puyallup, WABuilt 1974 · S/N 17264064 N2243EFord William H · Downers Grove, ILBuilt 1978 · S/N 17271202 N22467Mustang Sally Aviation LLC · Camden, SCBuilt 2007 · S/N 172S10487 N2246ELauer Richard D · Mount Laurel, NJS/N 17271203 N22479Robinson Paul C · San Francisco, CABuilt 1974 · S/N 17264066 N2249EJones Jason Parker · Fayetteville, GABuilt 1978 · S/N 17271204 N224JAWingsleasing LLC · Wichita, KSBuilt 1986 · S/N 17276588 N224MAAir Future Airways Corp · Miami, FLBuilt 2000 · S/N 172S8613 N224VSM&G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 172S12893 N2250EDover Afb Aero Club · Dover Afb, DEBuilt 1978 · S/N 17271205 N2254URaritan Valley Flying School · Princeton, NJBuilt 1999 · S/N 17280684 N2255EJohnson Steven Allan · Palmer, AKBuilt 1982 · S/N 17275692 N22598Dimler Travis M · Alpine, TXBuilt 1974 · S/N 17264071 N225ANCalifornia In Nice Inc · San Jose, CABuilt 1986 · S/N 17276615 N225FRDi Donato Michael · Celina, TXBuilt 1980 · S/N 17273947 N225JSAircraft Holdings LLC · Edmond, OKS/N 17274385 N225MHMissall Zoe S · Ontario, NYBuilt 1974 · S/N 17263156 N225MJOsterhout Fred · Sedro Woolley, WABuilt 1964 · S/N 17250609 N225RARochester Air Center LLC · Canandaigua, NYBuilt 2005 · S/N 172S9803

Back to AD 90-06-03 R1