Registered aircraft · 18,497

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

N4889JRegistered aircraftBuilt 1967 · S/N D-8424 N488DDRegistered aircraftBuilt 1967 · S/N CE-143 N488DPRodarte Lionel · Downey, CABuilt 1974 · S/N E-522 N488FDLittleton Darrell D · Atlanta, TXBuilt 1968 · S/N D-8700 N488HPHigh Performance Aircraft LLC · El Cajon, CABuilt 1989 · S/N CE-1338 N488JFMentoraire LLC · Lake Forest, CABuilt 1953 · S/N G-298 N488RHI F Rooks & Associates LLC · Memphis, TNBuilt 1982 · S/N U20606488 N488SSale Reported · Friday Harbor, WASale reported, pending cancellationS/N 4140529 N488SJDeans Casing Service Inc · Holdenville, OKFirst renewal noticeBuilt 1977 · S/N 414-0959 N4890FSkyline Sheet Metal Inc · Troutdale, ORBuilt 1966 · S/N U206-0590 N4890QNew Frontier Aviation LLC · Fort Benton, MTBuilt 1976 · S/N 18802626T N4890RRebecca Lynn Flying Service Inc · Livingston, NYBuilt 1975 · S/N 18802408T N4891ZRustair Inc · Anchorage, AKBuilt 1980 · S/N U20606044 N4892VPonto Michael A · Edgewood, NMBuilt 1968 · S/N 30131 N4894JCapri Blue Aviation LLC · Norcross, GABuilt 1967 · S/N D-8430 N4895YKeating George W · Fayetteville, ARBuilt 1980 · S/N 21064033 N4896CFlying Paws LLC · Arvada, COBuilt 1975 · S/N 18502647 N4896EMcgrail Stephen M · South Dennis, MABuilt 1979 · S/N 18503899 N4896FPorter Carl S · Seymour, TXBuilt 1966 · S/N U206-0596 N4896JMyshatyn Michael · Eaton, COBuilt 1967 · S/N D-8435 N4896KBraxtal LLC · Kingfisher, OKBuilt 1979 · S/N P21000358 N4896QBecker Flying Service Inc · Hartington, NEBuilt 1976 · S/N 18802632T N4896RB&R Aerial Crop Care Inc · Connell, WABuilt 1975 · S/N 18802414T N4898CPalo Aerocraft Inc · Salem, VABuilt 1979 · S/N 21063659 N4898QTaylor Aviation Inc · Fort Benton, MTBuilt 1976 · S/N 18802634T N489CDFrg Aircraft Partnership LLC · Barefoot Beach, FLS/N 1591 N489HPHigh Performance Aircraft LLC · El Cajon, CABuilt 1989 · S/N CE-1343 N48ALHutchinson Scott · Missouri City, TXBuilt 1976 · S/N 21061658 N48AMGwc Air LLC · Madison, ALBuilt 1980 · S/N 414A0609 N48BWBroadmoor Bed And Breakfast LLC · Colorado Springs, COBuilt 1975 · S/N CE-582 N48CCC Baron LLC · Lafayette, LAFirst renewal noticeBuilt 1981 · S/N TH-1277 N48CMR Stephen Smith Inc · Wichita, KSS/N TE-985 N48DJVan Iwarden Tracy D · Vacaville, CAS/N 65-12684 N48FCSoarmates Inc · Missoula, MTFirst renewal noticeBuilt 1968 · S/N U206-1099 N48JGWulvik Frederik M · Wasilla, AKBuilt 1974 · S/N 18502391 N48JHFlying O Consulting LLC · Hammon, OKBuilt 1971 · S/N E-297 N48KLMills Kenneth J · Fort Mill, SCBuilt 2002 · S/N 0372 N48KUWildcat Aviation LLC · Wilmington, DEBuilt 1979 · S/N D-10303 N48LEFerguson William T · Fayetteville, TNBuilt 1969 · S/N E-155 N48LFKraxberger Scotty L · Salida, COBuilt 1964 · S/N D-7489 N48MHSeventh North Hangar LLC · Bolton, MAS/N D-9184 N48MWFour Echo X-Ray LLC · Boston, MABuilt 2007 · S/N TH-2173 N48REMountain Tide LLC · North Bend, ORBuilt 2002 · S/N 0404 N48RKKinnischtzke Lyle V · Mandan, NDBuilt 1989 · S/N CE-1396 N48RSColin A Oerton · Miami Beach, FLBuilt 1966 · S/N D-8250 N48TIndian Springs Cattle Co Ltd · Wilmington, DEBuilt 2000 · S/N E-3320 N48TXCulater LLC · Indianapolis, INBuilt 1985 · S/N TH-1493 N48TZVisibility Unlimited LLC · Carbon, INS/N E-1804 N48VAGeiser Corbin · Little Elm, TXBuilt 1977 · S/N 21061798 N48WCBaron Acquisition LLC · Wayne, PABuilt 1981 · S/N TJ-350

Back to AD 86-13-04 R3