Skip to content

Registered aircraft · 72,010

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:87-10-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:87-10-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:87-10-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:87-10-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:87-10-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:87-10-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.

N44132Punta Gorda Flying Club LLC · Cape Coral, FLBuilt 1974 · S/N 28-7425391 N4413ASaubert Steven R · Florence, ORBuilt 1956 · S/N 22-3741 N4413HCharlton Jeremiah · Rockford, ILBuilt 1978 · S/N 24-0728 N4413JMcgee Robert N · Conroe, TXBuilt 1967 · S/N 28-22809 N4413SBirmingham Flight Center LLC · Birmingham, ALS/N 17257905 N4413ZBlackcountry Flying Experience Inc · Kalispell, MTBuilt 1968 · S/N 18-8746 N44140Helmandollar Steven W · Elkhorn, NEBuilt 1974 · S/N 28R-7435298 N44146Raimo Joseph H · New York, NYBuilt 1974 · S/N 28-7415591 N4414JHtf Aviation LLC · Kalispell, MTBuilt 1967 · S/N 28-22810 N4414TRegistration Pending · Rockford, MIRegistration pendingBuilt 1972 · S/N 28R-7235041 N4414XMellett Aircraft Inc · Ambler, PABuilt 1975 · S/N 28-7690005 N44156Gamelli James T · Bridgeport, WVBuilt 1974 · S/N 28-7405224 N44157Gregoire Alexandra Jennifer · Orlando, FLBuilt 1974 · S/N 28R-7435299 N4415ACanter Russell L · Enterprise, KSBuilt 1956 · S/N 22-3743 N4415RNextgen Flight Academy Inc · Riverside, CABuilt 1974 · S/N 17263163 N44167Sound Technology Matters LLC · Zeeland, MIBuilt 1974 · S/N 28-7415594 N4416AAltendorf Richard C · Northwood, NDBuilt 1956 · S/N 18-5161 N4416JBoone Paint & Interiors Inc · Boone, NCBuilt 1967 · S/N 28-22871 N44171Sanders Michael L Jr · Plainfield, INBuilt 1974 · S/N 28-7415595 N44176Taylor Wilbur J Jr · Oro Valley, AZBuilt 1974 · S/N 28-7415596 N4417JPalmatier Seth · Chandler, AZBuilt 1967 · S/N 28-22814 N4417TBimini Bullet LLC · Lakeland, FLBuilt 1972 · S/N 32-7200021 N44189Lane Robert C · Calico Rock, ARBuilt 1974 · S/N 28-7415598 N4418JS B Enterprise LLC · Marshall, TXBuilt 1967 · S/N 28-22815 N4418RTeton Leasing LLC · Pocatello, IDBuilt 1974 · S/N 17263166 N4418TRankin Kevin K · Vandalia, OHBuilt 1972 · S/N 32-7240079 N4418ZHigh Wind Aviation Service LLC · Ludlow, VTBuilt 1968 · S/N 18-8753 N44191C H Aviation Services Inc · Wilmington, DEFirst renewal noticeBuilt 1976 · S/N 28-7690330 N44192Steere George O Jr · Chepachet, RIBuilt 1974 · S/N 28-7405226 N44193Brekhus Scotti · Cheyenne, WYBuilt 1974 · S/N 28-7405227 N44195Guthrie Aircraft Inc · Wadsworth, OHBuilt 1974 · S/N 28-7405228 N4419JN2893e LLC · Reno, NVBuilt 1965 · S/N 28-2641 N441ACAero Champ LLC · Orlando, FLS/N 401-97 N441AMFussell Aviation LLC · Mcrae-Helena, GABuilt 1966 · S/N 28-3688 N441APSisk Jared · Odessa, MOBuilt 1991 · S/N 1904 N441BJB & J Flying Service · Etters, PABuilt 2004 · S/N 10528 N441BMMillsap Ted I · Redding, CAS/N 28-22816 N441CAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280441 N441CHRegistration Pending · La Conner, WARegistration pendingBuilt 2002 · S/N 10012 N441CKWinters John H · Birch Run, MIBuilt 1975 · S/N 28R-7535314 N441DEWhirld Helicopters Inc · Sevierville, TNBuilt 2006 · S/N 11249 N441DLPinion Aviation Inc · Glenbrook, NVBuilt 1976 · S/N 17267391 N441DPRhinelander Flying Service Inc · Rhinelander, WIBuilt 1975 · S/N 17265691 N441DRDakota Rotors LLC · Custer, SDFirst renewal noticeBuilt 2004 · S/N 10375 N441EDGold Prop Aviation LLC · Auburndale, FLBuilt 1985 · S/N 327 N441EKSkf Holdings LLC · Breckenridge, TXBuilt 2002 · S/N 1190 N441ELRegistration Pending · Caledonia, WIRegistration pendingBuilt 2014 · S/N 90586 N441FLJustice Carrie · Plano, TXBuilt 1971 · S/N 28-7125230 N441HGGeorgia Aviation Authority · Eastman, GABuilt 1995 · S/N 4496003 N441HPMotorcarlease USA Inc · Miami Beach, FLBuilt 2000 · S/N T20608240

Back to AD 87-10-06 R1