Skip to content

Registered aircraft · 6,916

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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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.

N6016VTiseo Paul J · Chester, CTBuilt 2006 · S/N T18208541 N6017YTulsa Technology Center School District No 18 · Tulsa, OKS/N 27-3200 N601ALValley Group Inc · Fishersville, VABuilt 1969 · S/N 61-0036-73 N601BBKing Aviation Services LLC · Marietta, OHBuilt 1977 · S/N 61P-0431-159 N601EMValestin Donald P · Queen Creek, AZBuilt 1977 · S/N 61P-0389-131 N601GZDependable Drain Cleaning And Plumbing Repairs LLC · Lake Charles, LABuilt 1976 · S/N 61P-0371-119 N601MAlvis Michael Ernie DBA · Sparta, TNBuilt 1975 · S/N 61P-0253-046 N601PSchmidt Richard E · Fort Myers, FLBuilt 1979 · S/N 61P06587963306 N601RBBandy Robert W · Ridgecrest, CABuilt 1969 · S/N 61-0040-77 N601SHJohnson Martin L · Henderson, NVBuilt 1970 · S/N 61-0067-124 N601TVOrlando Aircraft Sales LLC · Orlando, FLBuilt 2000 · S/N 0836 N601XSmc Developers Inc · San Jose, CABuilt 1977 · S/N 61-0393-117 N6020KDuont LLC · Portola Valley, CABuilt 2004 · S/N T18208236 N6020ZTisdale Enterprises LLC · Pensacola, FLS/N T18208545 N6021LTrebil Properties LLC · Grove City, MNBuilt 2009 · S/N 4692121 N6022JPavise LLC · Midland, TXBuilt 2006 · S/N T18208550 N6022NStrong Brothers Aviation Inc · Leesburg, FLBuilt 2006 · S/N T18208551 N6023FAviation Systems & Service LLC · Mounds, OKBuilt 2006 · S/N T20608628 N6024NRegistered aircraftS/N 14605 N6024PJohn D Holderman · Sarasota, FLBuilt 1993 · S/N 14608 N6025EVictor Air LLC · Kirkland, WABuilt 2006 · S/N T18208565 N6025FLeeloo Air LLC · Reno, NVBuilt 2006 · S/N T18208566 N6025PThagair LLC · Reno, NVBuilt 2006 · S/N T18208567 N6025ZWind River Aviators LLC · Dubois, WYBuilt 2006 · S/N T18208568 N6028UDesert Sky Aviation LLC · La Quinta, CABuilt 2006 · S/N T18208538 N602DDSilver Creek Aviation Services · Fort Worth, TXBuilt 2012 · S/N T20609057 N602DEPpp Aviation LLC · Jasper, GABuilt 2022 · S/N T20609716 N602SCSale Reported · Marble Falls, TXSale reportedBuilt 2002 · S/N 3257286 N602SUCa 6.2 LLC · Titusville, FLBuilt 2023 · S/N 001 N6030YReddick Brent · Paragould, ARBuilt 1969 · S/N 27-4370 N6032THard Times Wy LLC · Helena, MTBuilt 2006 · S/N T18208554 N6032WKolb Jonah Allan · Underhill, VTBuilt 2006 · S/N T18208555 N6033BRmp Management Co Inc · Rancho Cucamonga, CABuilt 2006 · S/N T18208559 N6033KAirborne LLC · Spring Hill, FLBuilt 2006 · S/N T20608631 N60349Mb Aviation LLC · Mount Pleasant, TXBuilt 2006 · S/N T18208562 N6034YTan American Corporation · New York, NYRegistration revokedBuilt 1966 · S/N 27-3219 N6034ZN6034z LLC · Missoula, MTBuilt 2006 · S/N T18208560 N60356Gray Family Acquisitions LLC · Loomis, CABuilt 2006 · S/N T18208571 N6035ALandrys Aviation Services LLC · Pierre Part, LABuilt 2006 · S/N T18208563 N6035HExclusive Auto'S LLC · Preston, IDS/N T18208564 N6036AClive Consulting LLC · Dover, DEBuilt 2006 · S/N T18208573 N6038ZFlying C LLC · Oro Valley, AZBuilt 2001 · S/N 20038 N6039HMailing And Fulfilling America Inc · Fort Worth, TXFirst renewal noticeBuilt 2006 · S/N T18208581 N6039YAllen Aviation Inc · Aynor, SCBuilt 1966 · S/N 27-3224 N603DCSeed Hub LLC · Glenarm, ILBuilt 2017 · S/N T20609502 N6040STait Layne S · Bloomington, INBuilt 2006 · S/N T18208589 N6041SGaluardi Judith L · Berlin, MDBuilt 2007 · S/N 4636434 N60445Catskill Air LLC · Forestburgh, NYBuilt 2006 · S/N T18208593 N60448Rlf N60448 LLC · Soap Lake, WABuilt 2006 · S/N T18208594 N6044JJj Ventures LLC · Billings, MTBuilt 2006 · S/N T18208591

Back to AD 71-13-01 R1