North American/Aero Classics P-51D
Registered aircraft · 70
Aircraft of this model in the FAA registry, by N-number.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('6402304')
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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('6402304')
ORDER BY n_numberRun 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.
N10601American Airpower Heritage Fly Museum · Dallas, TXN1451DTeeters David · Salinas, CAN151AFHeritage Flight Museum · Burlington, WAN151BPPalm Springs Air Museum · Palm Springs, CAN151BW124x LLC · Walnut Creek, CAN151DSeghetti Brant C · San Tan Valley, AZN151DPStine Welding Inc · Bridgman, MIFirst renewal noticeN151JTEcho Matrix LLC · Bentonville, ARFirst renewal noticeN151MDCroutch Marvin L · Encino, CAN151MWGreene Charles A III · Pilot Point, TXN151SEEberhardt Marilyn Trustee · Danville, CAN151XHohun51d LLC · Lake Havasu City, AZN1751DSierra Sue LLC · Santa Ana, CAN2051DJetran LLC · Horseshoe Bay, TXN20MSPacwest P-51 LLC · Mcclellan, CAN251BPCielos LLC · Holderness, NHN2869DAcv Group LLC · Mckinleyville, CAN3333ENautical Investments LLC · Helena, MTN334FSDoyle Duane S Trustee · Castro Valley, CAN335Kohler Frederick G Trustee · Marathon, FLN339THOzark Management Inc · Jefferson City, MOFirst renewal noticeN351DTCh Two LLC · Kissimmee, FLN3580Hovey Scott R · Ione, CAN3751DBoone Richard · Wichita Falls, TXN38227Macallister Chris · Indianapolis, INN3BBWarbirds-3 LLC · Kalispell, MTN41749Goldsbury Christopher Jr · San Antonio, TXN4223AAmerican Aircraft Sales LLC · Livermore, CAN44727Mow Management Co LLC · Corona, CAN451BCP-51 Mustang LLC · Cheraw, SCN451MGLiberty Foundation Inc · Miami, FLN479FGTf-51d LLC · Springville, NYN514NHCenterline Holdings · Camden, DEN51ABPlane Fun Inc Tr Trustee · Snellville, GAN51CYOklahoma P-47 LLC · Edmond, OKN51DHBlack Pearl 51 LLC · Buffalo, NYN51DLLindair Inc · Sarasota, FLN51DTMerlin Magic LLC · Wilmington, DEN51HRF4u Inc · Dover, DEN51JBJeb P51d LLC · Philadelphia, PAN51JCCavanaugh Air LLC · Addison, TXN51JTThibodeau Joe · Englewood, CON51KDOlympic Jet Inc · Olympia, WAN51LWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN51MRKempf Brothers Aviation Partnership · La Center, WAN51PBBrookway Aviation LLC · Brookhaven, MSN51RH51rh LLC · Rexburg, IDN51TD'Alessandris John A · Bandon, ORN51ZMMustang High Flight LLC · Boise, IDN5410VHoffman Aircraft Holdings LLC · Kerman, CA
Back to North American/Aero Classics P-51D