Skip to content

Registered aircraft · 5,102

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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N3538RUS Department Of Homeland Security · Washington, DCBuilt 2001 · S/N T20608341 N3539UBechara Nizar E · Columbia, MDBuilt 1979 · S/N 31-7912120 N353CCThree Jay Enterprises LLC · Los Altos, CABuilt 1962 · S/N 500B-1230-105 N353SLSneaker Air Inc · Miami, FLBuilt 1979 · S/N 31-7952188 N3541FChandler Gregory E · St Albans, WVBuilt 2001 · S/N T18208078 N35438Kern County Sheriffs Department · Bakersfield, CABuilt 2001 · S/N T20608329 N35440Norwood Jon D · Damon, TXBuilt 2001 · S/N T20608327 N3544MValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-8012005 N3545JBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 18281023 N3545ZGrande Skyclub Inc · Merritt Island, FLBuilt 1979 · S/N 31-8012015 N35475Abd Corporation Inc · Tinian, MPBuilt 1979 · S/N 31-8052023 N3547BMlmce Company Inc · Winchester, VABuilt 1979 · S/N 31-8052017 N3547GCarto Flight Inc · Willoughby, OHBuilt 1979 · S/N 31-8052021 N3547TAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N T20608322 N3548BJaa Holdings LLC · Springfield, ILBuilt 1979 · S/N 31-8052025 N3548JCarden Kevin · Hoover, ALBuilt 1979 · S/N 31-8052027 N35497Fox Aircraft LLC · Bethel, AKBuilt 1979 · S/N 31-8052039 N3549XAirplane Four LLC · Miami, FLFirst renewal noticeBuilt 1980 · S/N 31-8052034 N3551CT23 Aviation LLC · Hutchinson, MNS/N 31-8012019 N3555KPerman Edward O Jr · Rainbow City, ALFirst renewal noticeBuilt 1980 · S/N 31-8012037 N3556XWest Bend Air Inc · West Bend, WIBuilt 1980 · S/N 31-8012042 N3556ZJohnson Paul A Trustee · Bloomfield Hills, MIBuilt 2001 · S/N T18208060 N35580Aero Charter New England Inc · Mansfield, MABuilt 1980 · S/N 31-8052075 N35584Aztec Worldwide Airlines Inc · Wilmington, DEBuilt 1980 · S/N 31-8052076 N3558XAwmr LLC · Conroe, TXBuilt 1980 · S/N 31-8052073 N3559QIndependence Air LLC · Advance, NCBuilt 1979 · S/N 32R-8029022 N355RZKpae Partners LLC · Issaquah, WABuilt 1997 · S/N 27-0235 N355SRMoonglow Aviation LLC · Dover, DEBuilt 2004 · S/N T20608458 N3560GVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N T18208063 N35679Mid Valley Flying LLC · Progreso, TXBuilt 1979 · S/N 32R-8029030 N356DBCaldwell Island LLC · Sherborn, MABuilt 1978 · S/N 31-7852056 N356MEGlass Cockpit Aviation-Sunvalley LLC · Hailey, IDBuilt 2000 · S/N 18280844 N356SFSheehan Aviation Family Enterprises LLC · Boise, IDS/N T20608496 N3576XField Aviation LLC · Fairview, TXBuilt 1979 · S/N 32R-8029035 N3577DAga Aviation LLC · Lewes, DEBuilt 1979 · S/N 32R-8029036 N3579QSchwartz Douglas · Plymouth, MIBuilt 1979 · S/N 32R-8029039 N357SAFox Aircraft LLC · Wasilla, AKBuilt 1980 · S/N 31-8052162 N35834Carto-Flight · Willoughby, OHBuilt 1980 · S/N 31-8052115 N35841Flyingvine LLC · Gilford, NHBuilt 1980 · S/N 31-8012054 N3586DDurrell Lee W · Memphis, TNBuilt 1980 · S/N 31-8012065 N3586XPops Aviation Inc · Spartanburg, SCBuilt 1980 · S/N 31-8012070 N3587PMsm587p LLC · Jericho, NYS/N 31-8052120 N35890Ja Aero LLC · Chicago, ILBuilt 1980 · S/N 31-8052139 N3589BAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052134 N3589XMarc Inc · Bolton, MSBuilt 1980 · S/N 31-8052138 N358ELCub Crafters Inc · Yakima, WABuilt 1996 · S/N E1 N3590BTranquil Air LLC · Lighthouse Point, FLBuilt 1980 · S/N 31-8052143 N3590DSale Reported · Xxx, OKSale reported, canceledBuilt 1980 · S/N 31-8052144 N35GGWilforge LLC · Phoenix, AZBuilt 1999 · S/N 4636207 N35RDIngersoll Grove LLC · Springfield, MABuilt 1977 · S/N 31-7852039

Back to AD 81-12-06 R1