Skip to content

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N7330YJordan Terry L · Hugoton, KSBuilt 1964 · S/N 30-378 N7330ZAlbertson James M · Slocomb, ALBuilt 1965 · S/N 25-3230 N7331LStibolt Paul E · New Richmond, WIBuilt 1974 · S/N 31P-7400210 N7331YNeubert Erich S · Dana Point, CABuilt 1964 · S/N 30-292 N7332PArnold Christian M · Waltham, MABuilt 1961 · S/N 24-2511 N7333KGreen Francis E · Frankfort, NYBuilt 1950 · S/N 20-240 N7333ZSoaring Society Of Dayton Inc · Waynesville, OHBuilt 1965 · S/N 25-3281 N7334YJg Air LLC · Cape Coral, FLBuilt 1964 · S/N 30-383 N7335KPeterman Karen S · Holiday, FLBuilt 1950 · S/N 20-243 N7336DJohnson Dale M · Seminole, TXBuilt 1957 · S/N 22-5125 N7336ZBruegger Traylin T · Lance Creek, WYBuilt 1965 · S/N 25-3285 N7338PPope Kent M · Hayden, IDBuilt 1961 · S/N 24-2517 N7339KMendez Jessica A · Jacksonville, FLBuilt 1950 · S/N 20-247 N733GPHorton Luther · Lakeland, FLBuilt 1962 · S/N 24-3213 N7340PWard James A · Brentwood, TNBuilt 1961 · S/N 24-2519 N7341DDunn Steven J · Youngsville, PAFirst renewal noticeBuilt 1957 · S/N 22-5130 N7341PBlaes Richard S · Columbus, OHBuilt 1960 · S/N 24-2520 N7342YHinkle Anthony · Mineola, TXBuilt 1964 · S/N 30-392 N7343DRautio Mitchell M · Bemidji, MNS/N 22-5132 N7344LRhs Consulting Ltd LLC · Reno, NVBuilt 1974 · S/N 31P-7400229 N7344PWorley Jimmy · Dallas, TXBuilt 1961 · S/N 24-2522 N7347DOwens Tyle M · Kenai, AKBuilt 1957 · S/N 22-5138 N7347PVan Eyck Christopher · Cottonwood, CABuilt 1961 · S/N 24-2525 N7348PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1961 · S/N 24-2526 N7348ZPittsburgh Soaring Association · Pittsburgh, PABuilt 1965 · S/N 25-3299 N7349KWimberly Fred N · Callao, VABuilt 1950 · S/N 20-256 N7349PMathison John M · Vancouver, WABuilt 1961 · S/N 24-2527 N7350KSmith Randy Kayle · Vancouver, WABuilt 1950 · S/N 20-258 N7350ZScott Ts Ag Flyin Inc · Colquitt, GABuilt 1965 · S/N 25-3302 N7351KFordham Gary B · Goldsboro, NCBuilt 1950 · S/N 20-259 N7351PSutliff Larrie G · Briarcliff Manor, NYBuilt 1961 · S/N 24-2529 N7353KIvey Thomas S · Gladewater, TXS/N 20-261 N7354DKerven Enterprizes Inc · Butler, PABuilt 1957 · S/N 22-5150 N7354YBreum Todd R · Billings, MTBuilt 1964 · S/N 30-408 N7355DSlavens Trent S · Whitehall, MIS/N 22-5151 N7355PGo Fly Az LLC · Gilbert, AZBuilt 1961 · S/N 24-2533 N7357DColton F D · Canby, ORBuilt 1957 · S/N 22-5155 N7357PMelvin Ryan C · Hamilton, GABuilt 1961 · S/N 24-2535 N7358DBagley S G · Suwanee, GABuilt 1957 · S/N 22-5156 N7358YPmx Aviation Services LLC · Kailua Kona, HIBuilt 1964 · S/N 30-413 N7358ZKingsley Kiman J · Miller, MOBuilt 1965 · S/N 25-3311 N7359YAwmr LLC · Conroe, TXBuilt 1964 · S/N 30-414 N7362PMead Gary M · Lubbock, TXBuilt 1961 · S/N 24-2540 N7363PJansen David C · Newnan, GABuilt 1961 · S/N 24-2541 N7364PMarotta Thomas E · Twin Lake, MIS/N 24-2542 N7365KKnutsen Wayne R · Tioga, NDBuilt 1950 · S/N 20-274 N7365YLoguidice Anthony · Bethlehem, PABuilt 1964 · S/N 30-416 N7366PAnthony Craig D · Keller, TXBuilt 1961 · S/N 24-2544 N7366YShockley Kenlon D · Aurora, COBuilt 1964 · S/N 30-417 N7366ZAerial Banners North Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3320

Back to AD 85-02-05 R1