Skip to content

Registered aircraft · 1,406

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:95-26-16-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:95-26-16-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:95-26-16-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:95-26-16-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:95-26-16-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:95-26-16-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.

N727KCWest Michigan Flying Club Inc · Norton Shores, MIBuilt 1994 · S/N 24-3350 N732YSCabana Management Inc · Myrtle Beach, SCBuilt 1992 · S/N 24-3269 N747ARDay Aviation Inc · Wilmington, DEBuilt 1994 · S/N 24-3345 N747CFEast Hill Flying Club Inc · Ithaca, NYBuilt 1977 · S/N 24-0196 N747LCKerwin Peter M · Naperville, ILBuilt 1992 · S/N 24-3259 N7677VDoxtator Christopher P · Covington, INBuilt 1982 · S/N 24-1328 N76EPFlorida Health Privilege LLC · Key West, FLBuilt 1998 · S/N 24-3425 N770CMMooney Blues Aviators Inc · Naples, FLBuilt 1998 · S/N 24-3416 N770DTBargemann Jeffrey Karl · Greenville, OHS/N 24-0337 N772DFLima Whiskey Flying Club · Harrisburg, PABuilt 1979 · S/N 24-0937 N777ECMitchener Michael Shane · Marlborough, MABuilt 1996 · S/N 24-3399 N777LTYates Deborah L · Pioneer, CABuilt 1978 · S/N 24-0691 N779JNTorque Aviation Inc · Smithfield, VABuilt 1978 · S/N 24-0605 N77ATRegistered aircraftBuilt 1981 · S/N 24-1233 N77EGParr Frank T · Pawleys Island, SCBuilt 1993 · S/N 24-3316 N781PGSword Christina Renee · Surprise, AZBuilt 1977 · S/N 24-0187 N781RMHotel Bravo LLC · Madisonville, LABuilt 1978 · S/N 24-0432 N782DJLeandro Eduardo · Orrtanna, PAS/N 24-1592 N78FMFraker Gregory M · Plymouth, MIBuilt 1978 · S/N 24-0768 N791FRD'Angelo Alexander · Parkland, FLBuilt 1979 · S/N 24-0930 N799ECCallaghan Frank · East Boothbay, MEBuilt 1979 · S/N 24-0920 N7LUNorber Howard S · Chicago, ILBuilt 1991 · S/N 24-3214 N800TBHamaoui Ness · Santa Ynez, CABuilt 1984 · S/N 24-1514 N801DWCompucore Networks LLC · Tucson, AZBuilt 1984 · S/N 24-1485 N803DWRamirez Denise K · Corona, CAS/N 24-1701-14 N816TSCd Logic Inc · Wilmington, DEBuilt 1985 · S/N 24-1562 N819SMAnderson George M · Hattiesburg, MSBuilt 1979 · S/N 24-0802 N8201ABeggs Daniel · Royston, GABuilt 1978 · S/N 24-0603 N8201BTammi Mark K · Grass Valley, CABuilt 1978 · S/N 24-0604 N8201QEhmka Mitchell · Lombard, ILBuilt 1978 · S/N 24-0606 N8201XPotter Jan Charles · Tangerine, FLBuilt 1978 · S/N 24-0609 N823SPUberti Christopher · Brighton, MIBuilt 1976 · S/N 24-0003 N824MMRelevant Enterprises Inc · Kalispell, MTBuilt 1977 · S/N 24-0352 N825TMHigher Plane LLC · Las Vegas, NVBuilt 1982 · S/N 24-1300 N828DPZepponi Dan · Napa, CABuilt 1983 · S/N 24-1348 N82AGN82ag LLC · Dahlonega, GABuilt 1982 · S/N 24-1270 N82KLMcdaniel Michael Ray · Hampton Cove, ALBuilt 1977 · S/N 24-0280 N830FJVujic Aleksandar · Kensington, MDBuilt 1997 · S/N 24-3407 N838HGVanmeetern Robert · Reedsburg, WIBuilt 1985 · S/N 24-1566 N84ERDelapp Duncan P · Camino, CABuilt 1981 · S/N 24-1160 N858JBSale Reported · El Mirage, AZSale reportedBuilt 1977 · S/N 24-0376 N860BCJacobs Hunter L · Hood River, ORBuilt 1979 · S/N 24-0860 N860DCHarrison John Kevin · Durham, NCBuilt 1985 · S/N 24-1561 N868FACardoza Todd J · Castro Valley, CAS/N 24-0980 N86BFEmbotelladora Del Caribe Inc · Yabucoa, PRBuilt 1981 · S/N 24-1223 N87ERSollenbarger Donald · Johnson City, TXS/N 24-1397 N87PMMona LLC · Kalispell, MTBuilt 1983 · S/N 24-1386 N885JBrandaleone Nicholas · Somerville, MABuilt 1990 · S/N 24-3192 N888DFAslin Wesley Keith · Auburn, CABuilt 1992 · S/N 24-3254 N88EFPeyton Craig L · Rhinebeck, NYBuilt 1979 · S/N 24-0815

Back to AD 95-26-16 R1