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.

N5298SSix Ten Ventures LLC · Grand Prairie, TXBuilt 2002 · S/N 172S9246 N5298VGeorgia Building Solutions LLC · Cleveland, GABuilt 1980 · S/N 172RG0501 N52993Journeys Aviation Inc · Boulder, COBuilt 1981 · S/N 17274654 N5299DPremier Flight Center LLC · Hartford, CTBuilt 1979 · S/N 17272501 N529CANeufeld Don I · Fairview, OKS/N 17269104 N529ERPs N529er LLC · Green Bay, WIBuilt 2002 · S/N 172S9111 N529LFEnterprise Aviation Services LLC · Albuquerque, NMBuilt 1976 · S/N 17267970 N529MCRhoads Eric S · Costa Mesa, CABuilt 1981 · S/N 17274639 N529NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10981 N529TDJohnson Timothy Dean · Walton, KYBuilt 1972 · S/N 17260741 N52LULetourneau University · Longview, TXBuilt 2024 · S/N 172S13198 N53009Triple V Aviation LLC · Long Valley, NJBuilt 1981 · S/N 17274658 N5300KSliviak Thomas V · Leechburg, PABuilt 1980 · S/N 17274053 N53010L & T Aviation Inc · Frederick, MDFirst renewal noticeBuilt 1981 · S/N 17274659 N53017Johnston Charles L II · Nashville, TNBuilt 1981 · S/N 17274663 N5301EMaxwell Don P II · Longview, TXBuilt 1978 · S/N 17271827 N53020Iasco Flight Training Inc · Redding, CABuilt 2002 · S/N 17281136 N53023N53023 Aloha LLC · Palm City, FLBuilt 1981 · S/N 17274665 N53025Beumer Ted Anthony · Pensacola, FLBuilt 1981 · S/N 17274666 N5302RTrinque Robert L Trustee · Plymouth, MABuilt 1965 · S/N 17252823 N5302THoak Edward C · Hummelstown, PABuilt 1964 · S/N 17251202 N53037Mb Airworks LLC · Palmetto Bay, FLS/N 17274669 N53039Laurel Highlands Aeronautical Academy · Latrobe, PAS/N 172S9259 N5303EQuinn George F · Amherst, NHBuilt 1978 · S/N 17271829 N5303JGulf Coast Aviation LLC · New Orleans, LABuilt 2002 · S/N 172S9254 N5303TMorey Airplane Co Inc · Middleton, WIBuilt 2002 · S/N 172S9255 N53045East Hill Flying Club Inc · Ithaca, NYBuilt 1981 · S/N 17274672 N5304EDornink Farms LLC · Freeport, ILS/N 17271830 N5304FHurt J William · Hachita, NMBuilt 1979 · S/N 17273131 N5304RSouthern Arkansas Univ Tech · Camden, ARFirst renewal noticeBuilt 1965 · S/N 17252826 N5304TR Gerald Hough III · Mount Morris, ILBuilt 1964 · S/N 17251204 N53054Ott Robert · Medina, OHBuilt 1981 · S/N 17274674 N5305KJ M F And Associates Inc · Alexandria, VABuilt 1980 · S/N 17274055 N5305RWoodman Larry · Nottingham, NHBuilt 1965 · S/N 17252827 N5305TMccall Freddie W · Brewton, ALBuilt 1964 · S/N 17251205 N5305VAmerican Academy Of Aeronautics Inc · Stanford, CAS/N 172RG0504 N53065Cherry Hill Aviation LLC · Freetown, INBuilt 1981 · S/N 17274676 N53068Legends Air Center LLC · Bentonville, ARBuilt 2002 · S/N 172S9265 N53069Northwoods Air LLC · Orono, MEBuilt 1981 · S/N 17274678 N5306CSo Cal Leasing LLC · El Cajon, CABuilt 2002 · S/N 172S9269 N5306EN5306e LLC · Ashburn, VABuilt 1978 · S/N 17271832 N5306KMills Bradley W · Wichita Falls, TXBuilt 1980 · S/N 17274056 N5306RSheldon Scott H · Cohasset, MABuilt 1979 · S/N 172RG0051 N5306UAircraft Solutions Group LLC · Englewood, COBuilt 2002 · S/N 172S9264 N53070Wnc Aviation LLC · Arden, NCBuilt 2003 · S/N 172S9325 N53077Megasky Holdings LLC · Charleston, SCBuilt 1981 · S/N 17274679 N5307RFabian Brian L · Corcoran, MNBuilt 1965 · S/N 17252829 N53087Colorado North Western Community College · Rangely, COBuilt 1981 · S/N 17274681 N5308TAvventura LLC · San Marcos, CAFirst renewal noticeBuilt 1964 · S/N 17251208 N5309FMedary Aviation LLC · Brookings, SDS/N 172S9273

Back to AD 90-06-03 R1