Skip to content

Registered aircraft · 81,728

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-18-04-R2') 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-18-04-R2') 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-18-04-R2')
    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-18-04-R2')
  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-18-04-R2')
  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-18-04-R2')
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.

N307RBHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1999 · S/N 3007 N307RSScott Robert K · Sullivan, MOBuilt 2023 · S/N 1985 N307RTNorthwest Aircraft LLC · Anaconda, MTBuilt 1990 · S/N 768 N307SHParker Helicopters Inc · Watsonville, CABuilt 2023 · S/N 30097 N307SPSheridan Pilots 307 LLC · Sheridan, WYBuilt 1979 · S/N 17273438 N30800Congdon Carl J · Manley Hot Springs, AKBuilt 1970 · S/N 17701471 N30803Vampire Aviation LLC · Wilmington, DEBuilt 1996 · S/N 960 N30805Joshua Apodaca · Glendale, AZBuilt 1970 · S/N 17701474 N30807Edwards Garland U · Midlothian, VABuilt 1970 · S/N 17701476 N30809Brooks Sondra · Callicoon, NYBuilt 1993 · S/N 231 N3080ESky Safety Inc · San Antonio, TXBuilt 1978 · S/N 17271433 N3080MSuper Cruiser LLC · Palm City, FLS/N 12-1768 N3080ZEriksson Kurt R · Soldotna, AKBuilt 1959 · S/N 18-7131 N3081EWilliams Gregory B · Verona, WIBuilt 1982 · S/N 18268232 N3081PVan Zant Robert E · Salem, WIS/N 23-999 N30822Hogancamp John M · Lebanon, TNBuilt 1994 · S/N 22003C N30823Indian Hills Community College · Ottumwa, IAS/N 28-7816548 N30824Rude Allen · Mcville, NDBuilt 1970 · S/N 17701486 N30826Grundy James W · W Greenwich, RIBuilt 1970 · S/N 17701487 N30828Lary Leanne K · Thousand Oaks, CAS/N 17701489 N3082CJets To Helis LLC DBA · Chandler, AZBuilt 2007 · S/N 4231 N3082EAirgo Inc · Centralia, ILFirst renewal noticeBuilt 1978 · S/N 17271435 N3082THayes Travis · Warsaw, MOFirst renewal noticeBuilt 1972 · S/N 28-7310002 N3082XJet X Leasing Inc · Johnson, KSBuilt 1957 · S/N 18-4668 N3082ZRagwing Aero LLC · Brooksville, MSBuilt 1959 · S/N 18-7135 N30835Landis Wayne G · Bellingham, WABuilt 1970 · S/N 17701495 N3083MWeakley Companies LLC · Poland, NYBuilt 1947 · S/N 12-1771 N3083TLaubscher John E · Cazenovia, NYBuilt 1972 · S/N 28-7205313 N30841Mulliken Jerry A · Nickerson, NEBuilt 1970 · S/N 17701499 N30851Cohorst Jason P · Shawnee, KSBuilt 1970 · S/N 17701502 N30852Navonics Inc · Bluffton, SCBuilt 1970 · S/N 17701503 N30853Bas Part Sales LLC · Greeley, COBuilt 1970 · S/N 17701504 N30856Groothius Duane A · Rosemount, MNBuilt 1970 · S/N 17701507 N30858Freeman Anita · Marshfield, MOBuilt 1970 · S/N 17701509 N3085GRegistration Pending · Wasilla, AKRegistration pendingBuilt 1968 · S/N 91 N3085MCooley Pamela C · New Durham, NHBuilt 1947 · S/N 12-1773 N3085THewett Brian · Yankee Hill, CABuilt 1966 · S/N 28-3044 N3085YMarsh Aviation Of Marana Inc · Marana, AZFirst renewal noticeS/N 25-4265 N30860West Michigan Flying Club Inc · Norton Shores, MIBuilt 1970 · S/N 17701510 N30861Blake Bobby J · Eugene, ORS/N 17701511 N30866Davis Joseph G Jr · Durham, CTBuilt 1970 · S/N 17701514 N30869Hallford Aviation LLC · Cleveland, MSBuilt 1970 · S/N 17701517 N3086EMcclurkin David A · Norman, OKBuilt 1978 · S/N 17271436 N3086HGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N 27-7754144 N3086MBouschor William V · Curtis, WABuilt 1947 · S/N 12-1774 N3086SAmo Air & Claims LLC · Grove, OKS/N 17256700 N3086TAlba Aviation Services Inc · Scottsdale, AZBuilt 2006 · S/N 4047 N3086ZJohnston Kirk C · Chugiak, AKBuilt 1960 · S/N 18-7437 N30870Sabovich Ronald M · Port Orchard, WABuilt 1970 · S/N 17701518 N30871N30871 LLC · Rochester Hills, MIBuilt 1970 · S/N 17701519

Back to AD 81-18-04 R2