Skip to content

Registered aircraft · 3,118

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:82-23-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:82-23-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:82-23-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:82-23-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:82-23-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:82-23-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.

N7273PBrice Brandon Scott · Denver, COBuilt 1961 · S/N 24-2449 N7274PKeil Ronald B · Lapeer, MIBuilt 1961 · S/N 24-2450 N7275YCross John Benjamin · Lake Charles, LABuilt 1964 · S/N 30-314 N7277YDouble A Investments Inc · Rowland, NCBuilt 1964 · S/N 30-315 N7279YChormicle James R · Littlerock, CABuilt 1964 · S/N 30-317 N727DSYso Noz LLC · Grandville, MIBuilt 1958 · S/N 24-276 N727RMMarkle Robert L Jr · Cranberry Township, PABuilt 1965 · S/N 30-806 N7281PGuardian Peaks Airways LLC · Portland, ORBuilt 1961 · S/N 24-2458 N7281YGo For Flight LLC · Minneapolis, MNBuilt 1964 · S/N 30-319 N7286YReagan Scott Lllp · Mount Pleasant, SCBuilt 1964 · S/N 30-324 N7287PTwo Dot Aircraft LLC · Kalispell, MTBuilt 1961 · S/N 24-2465 N7288YN7288y LLC · Manassas, VABuilt 1964 · S/N 30-326 N7290PFarmland Investments Inc · Mound City, MOBuilt 1961 · S/N 24-2468 N7294YTgaap Inc · Dover, DEBuilt 1964 · S/N 30-333 N72DNPostiglione Daniel · West Babylon, NYBuilt 1971 · S/N 24-5006 N72MWStaggs Austin · Cudjoe Key, FLBuilt 1963 · S/N 30-171 N72SB72 Sierra Bravo LLC · Allegany, NYBuilt 1971 · S/N 24-4969 N7300YAdriatic Holdings LLC · Cheyenne, WYBuilt 1964 · S/N 30-341 N7302YJohnson Robert Daniel · Seabrook, TXBuilt 1964 · S/N 30-345 N7303PWeisend Chad · Peru, INBuilt 1961 · S/N 24-2478 N7304YN3024d LLC · Reno, NVBuilt 1964 · S/N 30-349 N7305YRegistered aircraftBuilt 1964 · S/N 30-350 N7309PEvergreen Underground Water Conservation District · Pleasanton, TXS/N 24-2484 N7309YGlaser William Burnett · New Smyrna Beach, FLS/N 30-296 N7311YInternational Air Services Inc Trustee · Carson City, NVBuilt 1964 · S/N 30-354 N7313YPr Aeronautics LLC · Buffalo, SDBuilt 1964 · S/N 30-356 N7316PCase Mark A Trustee · Shady Shores, TXBuilt 1961 · S/N 24-2492 N7317YComanche Air Services LLC · Westminster, COBuilt 1964 · S/N 30-360 N7318YBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 30-361 N731WN64gs LLC · Van Nuys, CABuilt 1971 · S/N 24-4989 N7320YSpruce John P · Liberty Hill, TXBuilt 1964 · S/N 30-364 N7321PTappan East LLC · New Philadelphia, OHBuilt 1961 · S/N 24-2498 N7322PRuple Michael D · Palm Bay, FLBuilt 1961 · S/N 24-2499 N7323PDurham Damon Patrick · Ripley, TNBuilt 1961 · S/N 24-2500 N7323YFoster Jay W · Marshfield, MOBuilt 1964 · S/N 30-367 N7324PWright Havis L · Pleasant Hill, MOBuilt 1961 · S/N 24-2502 N7324YMccaslin Dale Alan Trustee · Holt, MOBuilt 1964 · S/N 30-369 N7326PHarris David M · Costa Mesa, CABuilt 1961 · S/N 24-2504 N7326YHighsky Aero Inc · Arlington, TXBuilt 1964 · S/N 30-371 N7327PTown Terry N · Lake Havasu City, AZBuilt 1961 · S/N 24-2505 N7327YGeyman Edward J · Wilmington, OHBuilt 1964 · S/N 30-372 N7328PCoffee Bean Connoisseur LLC · Highland, NYBuilt 1961 · S/N 24-2506 N7328YBarnett David K · Brock, TXS/N 30-374 N7329PSlm Holdings LLC · Kalispell, MTBuilt 1961 · S/N 24-2507 N732CATrey Stroup Aviation LLC · Fort Pierre, SDBuilt 1966 · S/N 30-1086 N7330PGenpack LLC · Hillsdale, NJBuilt 1961 · S/N 24-2509 N7330YJordan Terry L · Hugoton, KSBuilt 1964 · S/N 30-378 N7331YNeubert Erich S · Dana Point, CABuilt 1964 · S/N 30-292 N7332PArnold Christian M · Waltham, MABuilt 1961 · S/N 24-2511 N7334YJg Air LLC · Cape Coral, FLBuilt 1964 · S/N 30-383

Back to AD 82-23-01 R1