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.

N5683RLewis George H · Brookline, NHBuilt 1965 · S/N 17253324 N5683TSkydotcom LLC · Inver Grove, MNS/N 17251583 N5684AGirard Richard J · Somerset, MABuilt 1956 · S/N 28284 N5684RGorton Horace B · Overland Park, KSBuilt 1965 · S/N 17253326 N5684TStahl Adam Charles · Fort Wainwright, AKBuilt 1964 · S/N 17251584 N5685THolland Bruce B · Mansfield, TXBuilt 1964 · S/N 17251585 N5686RLogan Kevin · Amarillo, TXS/N 17253329 N5687REsch Randall L · Stanton, MIBuilt 1965 · S/N 17253330 N5687TSchultz Josh · Blanchard, OKBuilt 1964 · S/N 17251587 N5688ASutton Aircraft Salvage LLC · Palmer, AKBuilt 1956 · S/N 28288 N5689AAffordable Aircraft LLC · Bellevue, MIS/N 28289 N568NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10806 N5690RMcveigh Ian Thomas · Mansfield, TXBuilt 1965 · S/N 17253334 N5690TJohnson Clinton A · Haughton, LABuilt 1964 · S/N 17251590 N5691RBase 2 Final Fleet LLC · Mckinney, TXBuilt 1965 · S/N 17253336 N5691TEsterly Bryan L · Hope Mills, NCBuilt 1964 · S/N 17251591 N5692AKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1956 · S/N 28292 N5695TJohnston David L · Williamsville, MOBuilt 1964 · S/N 17251595 N5696ACardinal Wings Inc · Faribault, MNBuilt 1956 · S/N 28296 N5696RMagnolia Flight Aviation LLC · Pontotoc, MSBuilt 1965 · S/N 17253343 N5697AHam Dana L · Claremore, OKBuilt 1956 · S/N 28297 N5697ERedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 17271922 N5698AGreer David S · Lubbock, TXBuilt 1956 · S/N 28298 N5699AOhlinger Judith A · Copley, OHBuilt 1956 · S/N 28299 N5699RNoriega Vanessa · Miami, FLS/N 17253349 N569FGMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10871 N569NDVertol Systems Co Inc · Destin, FLBuilt 2009 · S/N 172S11004 N569RJNational Training I LLC · Wilmington, DES/N 172S8896 N569SPGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 2000 · S/N 172S8494 N56ACLatham Randall W · Georgetown, OHBuilt 1964 · S/N 17252416 N56DGEagle East Aviation Inc · North Andover, MABuilt 1976 · S/N 17266239 N56ECBpc Aviation LLC · Rosamond, CABuilt 1962 · S/N 17249661 N56EPSanders Flight Training Center Inc · Jasper, ALBuilt 1978 · S/N 17270728 N56FAir Kings LLC · West Chester, PABuilt 1975 · S/N 17265348 N56FASilver Express Co DBA · Miami, FLBuilt 1978 · S/N 172-69682 N56JRMccollum Eric B · Fair Oaks, CAS/N 17248012 N56LJL & J Aviation Inc · Atwater, CABuilt 1979 · S/N 17272751 N56LUService Oriented Aviation Readiness S.O.A.R. · Bolivar, MOBuilt 2016 · S/N 172S11727 N56MWHeartland Ag Aviation LLC · Lancaster, KSBuilt 1975 · S/N 17265314 N5700ERegistration Pending · Fort Lauderdale, FLRegistration pendingBuilt 1978 · S/N 17271923 N5700RSpindler Dale A · Auburn, WABuilt 1965 · S/N 17253350 N5701ACrews James E Sr · Lawton, OKBuilt 1956 · S/N 28301 N5704AN8372x LLC · Chelan, WAS/N 28304 N5704TCorrigan Stephen J · Prescott, AZS/N 17251604 N5705RRucker David G · New Waverly, TXBuilt 1965 · S/N 17253359 N5707RIoele Brian · West Henrietta, NYBuilt 1965 · S/N 17253362 N5708AEgmond Aircraft LLC · Lewes, DES/N 28308 N5709RNick Monsen Trucking Inc · Buffalo Center, IABuilt 1965 · S/N 17253366 N570FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13455 N570JAJ A Flight Services LLC · Sugar Grove, ILBuilt 2007 · S/N 172S10575

Back to AD 90-06-03 R1