Skip to content

Registered aircraft · 17,027

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:72-03-03-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:72-03-03-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:72-03-03-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:72-03-03-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:72-03-03-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:72-03-03-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.

N6712SDunaire LLC · Mechanicsburg, PABuilt 1967 · S/N 15067512 N6713CClemens Jerry W · Benton, KSBuilt 1965 · S/N 18256662 N6715GCardwell Aubrey Lynn · Spring Branch, TXBuilt 1970 · S/N 15072215 N6715RRose Mary R · Portland, ORBuilt 1966 · S/N T210-0115 N6717GJet Airways Express Inc · Aventura, FLS/N 15072217 N6718SRoberts Brandon R · Bogata, TXBuilt 1967 · S/N 15067518 N6720GMcclintick Marshall Wyatt · Daniel Island, SCBuilt 1970 · S/N 15072220 N6720RJacobsen Ian M · Lincoln City, ORBuilt 1966 · S/N T210-0120 N6720SWilliams Kenneth J · Hampton, NYBuilt 1967 · S/N 15067520 N6721SRenwick Stephen P · Moss Beach, CABuilt 1967 · S/N 15067521 N6722GPiasa Flyers Inc · East Alton, ILBuilt 1970 · S/N 15072222 N6722SCampbell J Tyler · Chestertown, MDBuilt 1967 · S/N 15067522 N67236Cessna N67236 LLC · Harrah, OKBuilt 1964 · S/N 18255666 N6723GPressley Brandon S · York, SCBuilt 1970 · S/N 15072223 N6724RDavis Lease LLC · Fort Collins, COBuilt 1966 · S/N T210-0124 N6725FReberry Brian Keith · Boise, IDBuilt 1966 · S/N 15063325 N6725GJohnson Andrew E · Prior Lake, MNBuilt 1970 · S/N 15072225 N6725SMarshall Jerry J · Parker, AZBuilt 1967 · S/N 15067525 N6726FBlackford Robert G · Summit Point, WVS/N 15063326 N6727RChase Holden · Boulder, COS/N T210-0127 N6728SStevens Matthew S · Penn Yan, NYBuilt 1967 · S/N 15067528 N6729FLuke David E · Lubbock, TXS/N 15063329 N6729GBelgacem Yassine · Harrisburg, PABuilt 1970 · S/N 15072229 N6729RDfo Dynamic Aviation LLC · Glendale, AZBuilt 1966 · S/N T210-0129 N6729SCain Tyler M · Houston, TXBuilt 1967 · S/N 15067529 N6731SHaug Jeffrey S Trustee · Leawood, KSBuilt 1967 · S/N 15067531 N6732FSmith Tyler C · Wasilla, AKBuilt 1966 · S/N 15063332 N6732ROregonian Flying Club · Wilmington, DEBuilt 1966 · S/N T210-0132 N6733GAsaro Carlo · Waterbury, CTBuilt 1970 · S/N 15072233 N6735GRedeemed Flying Corps Association · Oklahoma City, OKBuilt 1970 · S/N 15072235 N6736FN6736f LLC · Port Saint Lucie, FLBuilt 1966 · S/N 15063336 N6736RD Kevin Lester Md Inc · Fresno, CABuilt 1966 · S/N T210-0136 N6737RJpk LLC · Waterloo, NEBuilt 1966 · S/N T210-0137 N6738FOakley Keith C · Montgomery, ALS/N 15063338 N6738GSpark Aero LLC · Christiansburg, VABuilt 1970 · S/N 15072238 N673ATCitizen Air LLC · Port Angeles, WABuilt 1976 · S/N U20603513 N673CBBurge Jerome C · Thousand Oaks, CABuilt 1970 · S/N 15072129 N6740FUwanawich Miller · Los Angeles, CAS/N 15063340 N6741TCavanaugh Flight Museum · Denison, TXBuilt 1966 · S/N R-172-0127 N6743RBas Part Sales LLC · Greeley, COBuilt 1966 · S/N T210-0143 N6744GRenfrow Denny M · Kelseyville, CAS/N 15072244 N6744SGoodrich Flying LLC · Corinne, UTBuilt 1967 · S/N 15067544 N6745RHurt Todd A · Springfield, ORBuilt 1966 · S/N T210-0145 N6746GKelsay Roger B · Hillsboro, ORS/N 15072246 N6746RSchwartz Daniel T · Meeker, COBuilt 1966 · S/N T210-0146 N6748FStone Charles N · Chetopa, KSBuilt 1966 · S/N 15063348 N6749FWright Steven · Shelbyville, TNBuilt 1966 · S/N 15063349 N6749RPmbarrett Aviation LLC · Tucson, AZBuilt 1966 · S/N T210-0149 N6750GWimberly Fred N · Callao, VABuilt 1970 · S/N 15072250 N6752FRdd Enterprises LLC · Redmond, ORBuilt 1966 · S/N 15063352

Back to AD 72-03-03 R3