Skip to content

Registered aircraft · 55

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:2001-01-11') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-01-11') 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:2001-01-11')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-01-11')
  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:2001-01-11')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-01-11')
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.

N101FHBadzelewicz-Hartl Irena · Scotch Plains, NJBuilt 1981 · S/N 4083 N114SZRutledge Todd K · Fishers, INBuilt 1989 · S/N 4731 N120RSRamsden Graham P · Omaha, NEBuilt 1981 · S/N 4092 N137RBRb Associates LLC · Shelburne, VTBuilt 1984 · S/N 4386 N13HHJames L Wallis · Davis, CABuilt 1983 · S/N 4204 N144LSCulp John M · Asheville, NCBuilt 1985 · S/N 4481 N180DBBarry John L · Aurora, COBuilt 1985 · S/N 4516 N23NHPinney Charles W · Tucson, AZBuilt 1982 · S/N 4205 N241UKHingst Douglas J · Rcho Sta Marg, CABuilt 1982 · S/N 4199 N242RLFellenz James D · Slippery Rock, PABuilt 1986 · S/N 4561 N245JDStallman Jon M · Chico, CABuilt 1983 · S/N 4329 N2YASmith Daryl N · Coventry, CTBuilt 1981 · S/N 4093 N30HHHayter Jr Henry W · Burlington, KYS/N 4026 N30RDMid-Atlantic Soaring Assoc · Frederick, MDBuilt 1982 · S/N 4209 N30SZCsa Foundation Inc · Wellington, COBuilt 1984 · S/N 4473 N3252ZShugg Gregory G · Flagler Beach, FLS/N 4206 N370JSJuliet Sierra LLC · Falls Church, VABuilt 1984 · S/N 4370 N39AWBlue Ridge Soaring Society · New Castle, VABuilt 1984 · S/N 4472 N39YMurowatz Walter E · Chino, CABuilt 1981 · S/N 4089 N3YAAero Club Albatross · Blairstown, NJBuilt 1984 · S/N 4402 N402KBlace Mark P · Spring Gap, MDBuilt 1981 · S/N 4009 N40WCGrinder Michael C · Fairfield, PABuilt 1981 · S/N 4096 N41WKMorgan Mark · Franklin, TNBuilt 1984 · S/N 4448 N41XXWelborn Matthew T · Pfafftown, NCBuilt 1980 · S/N 4007 N4204CUsher John R · Alcoa, TNBuilt 1981 · S/N 4088 N427JDavenport Kira L · Malta, NYS/N 4095 N42NSWright Robert L · Albuquerque, NMBuilt 1981 · S/N 4082 N440BHPundole Faraidoon N · Sugar Land, TXS/N 4098 N446JNTamayo George M · Bullhead City, AZS/N 4460 N44SLArmor John A · Villa Hills, KYBuilt 1981 · S/N 4197 N45THLane Christopher W · Conroe, TXBuilt 1981 · S/N 4085 N465CBTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1983 · S/N 4339 N46LKLindberg David V · Snohomish, WAS/N 4411 N49EHPoling David R · West Chester, PAS/N 4005 N49LSVan Lieu Neil R · Fort Collins, COBuilt 1985 · S/N 4483 N52ABMead Colin E · Jacksonville Beach, FLBuilt 1980 · S/N 4006 N54LSShugg Mark D · Merritt Island, FLBuilt 1980 · S/N 4075 N565NMckerlie Charles · San Diego, CABuilt 1985 · S/N 4503 N60LSBravo Charlie Soaring LLC · Port Matilda, PABuilt 1983 · S/N 4192 N64LSSeifried Paul E · Branchville, NJBuilt 1983 · S/N 4299 N65LSPruitt Paul N · Santa Barbara, CABuilt 1983 · S/N 4353 N65RBGrandbear Air LLC · Morgan, UTBuilt 1982 · S/N 4208 N68RMEagleville Soaring Inc · Eagleville, TNS/N 4416 N71JWTeneyck Robert D · Santa Barbara, CAS/N 4385 N74KHHoover Wayne C Jr · Lawrenceville, GABuilt 1985 · S/N 4511 N76LSMahoney Arthur W · Sandy, UTBuilt 1980 · S/N 4077 N787CWWelsh Christopher R · Cresson, TXS/N 4090 N7LRArgentina Trade Inc · Wilmington, DES/N 4087 N814LSThornton Todd A · Laguna Beach, CAS/N 4084 N84HRBanas Frank Jr · Bellefonte, PABuilt 1984 · S/N 4438

Back to AD 2001-01-11