Skip to content

Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N461CDRiver City Leasing LLC · Lakeville, MNBuilt 2004 · S/N 1189 N461DAGrave Eugene G · Spencer, INS/N D-8572 N461DKMark Andregg Dds Pc · Tulsa, OKBuilt 1985 · S/N 46-8508102 N4620YCenturion Travel LLC · Fort Worth, TXBuilt 1980 · S/N 21063960 N4621MBassline Logistics LLC · Watauga, TNS/N TH-919 N4621QFitzgerald Barry Eugene · Springfield, ILBuilt 1971 · S/N 21059521 N4622QBas Part Sales LLC · Greeley, COS/N 21059522 N4623FHatfield William G · Nunica, MIBuilt 1966 · S/N P206-0223 N4624KHoyt Matthew P · Newport Beach, CABuilt 1979 · S/N P21000243 N4624QBowen Kennith M II Trustee · Winters, CABuilt 1971 · S/N 21059524 N4625MSchuster Alexander · Santa Rosa, CABuilt 1978 · S/N E-1247 N4625QBank Of Utah Trustee · Salt Lake City, UTBuilt 1971 · S/N 21059525 N4626FKrumpe Brothers LLC · Hagerstown, MDBuilt 1966 · S/N P206-0226 N4626KWyeth Patrick B Trustee · Chino Valley, AZBuilt 1979 · S/N P21000244 N4627KIsbell Brian · Rosenberg, TXBuilt 1979 · S/N P21000245 N4627QMassey Larry A · New Braunfels, TXBuilt 1971 · S/N 21059527 N4629FCandler Richard A · Sharpsburg, GABuilt 1966 · S/N P206-0229 N4629KAuburn Farms LLC · Auburn, KSBuilt 1979 · S/N P21000247 N462CDSouth Fork Group LLC · Belmont, NCBuilt 2005 · S/N 1546 N462HSAmelia Ann Cruzing LLC · Sibley, LABuilt 2003 · S/N 0775 N462WWPlane Metrics LLC · Fort Worth, TXBuilt 2001 · S/N LIV-462-SFB N4630NHyannis Air Service Inc · Hyannis, MABuilt 1978 · S/N 402C0001 N4631CGraves Martin · Odessa, TXBuilt 1979 · S/N 21063582 N4633MJ & S Aviation LLC · Clinton, MOS/N CE-816 N4634FCardinal Air LLC · Wynantskill, NYBuilt 1966 · S/N P206-0234 N4634MLearned Doug · Corral De Tierra, CAS/N D-10122 N4634U4634u LLC · Taylor, AZS/N U20605015 N4635GN535j LLC · Bismarck, NDBuilt 1977 · S/N 414-0906 N4636KAdvanced Database Designs LLC · San Ramon, CABuilt 1979 · S/N P21000248 N4637ALucky Dog Air LLC · Edmond, OKS/N D-9158 N4637UWright Air Service Inc · Fairbanks, AKBuilt 1979 · S/N U20605017 N4638EMorelock Colleen P Trustee · Beavercreek, OHS/N 18503822 N4638FSkydive Lake Tahoe LLC · Tahoe City, CABuilt 1966 · S/N P206-0238 N4639QGrundmann Karl · Manassas, VABuilt 1971 · S/N 21059539 N4640EState Of Utah · Salt Lake City, UTBuilt 1979 · S/N 18503824 N4640FDouglas Mark S DBA · Bellingham, WABuilt 1966 · S/N P206-0240 N4640GHonea Richard S · Canton, GABuilt 1976 · S/N 414-0908 N4644CMassmanf Darrel F · Ogdensburg, WIBuilt 1974 · S/N 18502585 N4644FBrennan Timothy R Trustee · Mount Pleasant, SCBuilt 1966 · S/N P206-0244 N4644UWineglass Holdings LLC · Fort Davis, TXBuilt 1983 · S/N 21064797 N4645FScruggs Ken R · Galloway, OHS/N P206-0245 N4646CWilliam Michael Moody · Anchorage, AKBuilt 1975 · S/N 18502586 N4648ATimms Chet D · Central City, IABuilt 1983 · S/N P21000812 N4648FSimmons Daniel A · Huntsville, ALBuilt 1966 · S/N P206-0248 N4648SKoehn Danny · Montezuma, KSBuilt 1975 · S/N E-767 N4649EStanberry Carl W · Anchorage, AKS/N 18503830 N4649UMy Holdings Inc · Anchorage, AKBuilt 1979 · S/N U20605028 N464DCDelta Charlie Aviation LLC · Glendale, AZBuilt 1979 · S/N 421C0709 N464EABaron Four LLC · Virginia Beach, VABuilt 2012 · S/N TH-2349 N464GSHooper Mark · Elko, NVBuilt 1978 · S/N U20604744

Back to AD 86-13-04 R3