Skip to content

Registered aircraft · 20,483

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

N20914Jackson George F Jr · Saint Leonard, MDBuilt 1972 · S/N 18261294 N2091XBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 18256191 N20920Berry Danny · Rusk, TXBuilt 1972 · S/N 18261295 N20923Langford Thomas R Jr · Mount Clare, WVBuilt 1972 · S/N 18261298 N20929Heinl Christopher · Hickory, NCBuilt 1972 · S/N 18261301 N2092GUllrich Sandy J · Haskell, OKBuilt 1958 · S/N 51392 N2092SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N 21061058 N20935White Mark · Cadiz, KYBuilt 1972 · S/N 18261306 N20936Nedbalek Brent · Brenham, TXS/N 18261307 N2093BTextron Aviation Inc · Wichita, KSBuilt 2003 · S/N 18280041 N2093GNew Herschel Dudley Jr · Savannah, GABuilt 1958 · S/N 51393 N20944Moody Robert L · Ava, MOFirst renewal noticeBuilt 1972 · S/N 18261313 N20945Georgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281295 N20946Local News LLC · Janesville, WIBuilt 1972 · S/N 18261315 N20948Wallin Rolf B · Fayetteville, NCBuilt 1972 · S/N 18261316 N20955Dimich Milan C · La Jolla, CABuilt 1972 · S/N 18261320 N2095GRegistration Pending · Bozeman, MTRegistration pendingS/N 51395 N2095RTyson John H · Melba, IDS/N 18255295 N2095XMiller Michael D · Goffstown, NHBuilt 1965 · S/N 18256195 N20962Fairmont Field LLC · Enid, OKBuilt 1972 · S/N 18261324 N20966Gibson Todd W · Madisonville, LABuilt 1972 · S/N 18261327 N2096RBeasley Tim · Summerland Key, FLBuilt 1964 · S/N 18255296 N20970Hitt James Randy · Blue Springs, MSBuilt 1972 · S/N 18261330 N20972Esmiol Matthew · Marlborough, CTBuilt 1972 · S/N 18261331 N20975American Union Printing Inc · Chino Valley, AZBuilt 1972 · S/N 18261333 N20976Kwolik Jordan M · Mckinney, TXBuilt 1972 · S/N 18261334 N20978Crosswinds Flying Club Inc · Oakland, MIBuilt 1972 · S/N 18261336 N2097RWilson Wayne D · Saratoga Springs, NYBuilt 1964 · S/N 18255297 N2097SLong Island Aviators LLC · Seaford, NYBuilt 2004 · S/N 18281308 N2097XSouth Carolina Forestry Commission · Columbia, SCBuilt 1965 · S/N 18256197 N20980White Duane A · Wappingers Falls, NYBuilt 1972 · S/N 18261337 N20986Skylane Flying Club Inc · Omaha, NEBuilt 1972 · S/N 18261342 N2098XKuefler Michael J · Saint Ignatius, MTBuilt 1965 · S/N 18256198 N2099GHilten Robert W · Columbus, MTBuilt 1958 · S/N 51399 N2099NMicheal Charles E · Arlington, TXBuilt 2004 · S/N 18281333 N2099XGreen Glen A · Willits, CABuilt 1965 · S/N 18256199 N20BRYork Stanley A · Leetonia, OHBuilt 1955 · S/N 31563 N20CHRegistered aircraftBuilt 1974 · S/N 18263453 N20DEEbright Sean E · Hasty, COS/N 51334 N20FCLge Flying Club Inc · Marietta, GABuilt 1970 · S/N 18260314 N20HBMontana Sky Aircraft LLC · Kalispell, MTS/N 18262945 N20HLCs&P Rocky Mountain Inc · Cypress, TXS/N 21061877 N20JSOyaski Michael F · Ebensburg, PABuilt 1975 · S/N 18263751 N20KHN20kh LLC · Clewiston, FLBuilt 2021 · S/N 18283153 N20KJOxford Flying Club Inc · Oxford, CTBuilt 1998 · S/N 18280143 N20WGBingham James H · Dillingham, AKS/N 33734 N21000Yunger John C · Newton, WIBuilt 1972 · S/N 18261346 N21001Global Acquisitions Ltd · Davenport, IAS/N 18261347 N21004M & J Aviation LLC · Clarkston, MIBuilt 1972 · S/N 18261349 N21006Lerma Gilbert L Sr · Salome, AZBuilt 1972 · S/N 18261351

Back to AD 84-10-01 R1