Skip to content

Registered aircraft · 1,446

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 ('2071826')
  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 ('2071826')
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.

N1440QN1440q LLC · Maybee, MIS/N 15072740 N1441QSale Reported · Franklin, INSale reportedBuilt 1971 · S/N 15072741 N1442QDelaware Aviation LLC · Sidney, NYFirst renewal noticeBuilt 1971 · S/N 15072742 N1444QPelco Aviation Inc · Hampton Bays, NYBuilt 1971 · S/N 15072744 N1446QBeek Dudley Ernest · Miami, FLFirst renewal noticeS/N 15072746 N1448QWjs Aircraft LLC · New Smyrna Beach, FLBuilt 1971 · S/N 15072748 N1449QAero Maintenance Inc · Vancouver, WABuilt 1971 · S/N 15072749 N144CRFrantz David L · Manchester, TNFirst renewal noticeBuilt 1973 · S/N 15075438 N1455QJackson Scott G · Layton, UTS/N 15072755 N1461QMarquez Christopher D · Fleming Island, FLBuilt 1971 · S/N 15072761 N1471QRader Gregory · Baldwin City, KSBuilt 1971 · S/N 15072771 N1476QHarley Dennis E Sr · Cole Camp, MOBuilt 1971 · S/N 15072776 N1483QAttax LLC · Missoula, MTBuilt 1971 · S/N 15072783 N1484QIntegrated Structural Services Inc · Ringgold, GABuilt 1971 · S/N 15072784 N1485QMartin Aviation LLC · Bargersville, INS/N 15072785 N1488QTorney Sean M · Angier, NCBuilt 1971 · S/N 15072788 N1492QDavison James D · Richmond, MAS/N 15072792 N1494QSauter Allen · Bismarck, NDBuilt 1971 · S/N 15072794 N1496QDonat Brandon L · Glendale, AZBuilt 1971 · S/N 15072796 N14HKTrolinger John D · Kerrville, TXBuilt 1971 · S/N 15072566 N1500QShoaff Mark · Lehigh, FLBuilt 1971 · S/N 15072800 N1505QN1505q LLC · Brunswick, GAS/N 15072805 N1506QDonald A D · Plano, TXBuilt 1971 · S/N 15072806 N1507QSafety In Motion Flight Center Inc · Puyallup, WABuilt 1971 · S/N 15072807 N1509QBeavers David · Strasburg, COBuilt 1971 · S/N 15072809 N150BNHernandez Ralph · San Antonio, TXS/N 15072767 N150BPRiffle Christopher Thomas · Charleston, SCBuilt 1972 · S/N 15073931 N150CEBrazier Glen A · Greenbush, MNBuilt 1973 · S/N 15073986 N150DBEvans Thomas J · Little Elm, TXBuilt 1972 · S/N 15074052 N150DDFuentes Daniel · Coral Springs, FLBuilt 1973 · S/N 15075327 N150DECopaair Maintenance Services Inc · Indiantown, FLBuilt 1972 · S/N 15073849 N150DLLedford Joseph Daniel · Cedartown, GAS/N 15075555 N150DPVendetti Michael J · Olney, MDBuilt 1970 · S/N 15072356 N150EBRegistered aircraftS/N 15072790 N150JGoode Stephen C · Canton, TXS/N 15072750 N150JJMedic Choppers LLC · Springdale, ARBuilt 1970 · S/N 15072231 N150JVHorizon Dreams LLC · Homer, GABuilt 1973 · S/N 15075395 N150KCPositive Rate Aviation LLC · Plano, TXBuilt 1972 · S/N 15074254 N150LStillwell Dennis L · Cascade, IDBuilt 1973 · S/N 15075206 N150LAEdwards Kellee L · Carson City, NVBuilt 1972 · S/N 15073266 N150LJL&C Aviation LLC · Trevorton, PABuilt 1971 · S/N 15072865 N150LSTrout David Lee · Lebanon, INS/N 15074694 N150MHHousley William M · Jasper, ALS/N 15074821 N150MWWoods Mark H · Las Vegas, NVBuilt 1974 · S/N 15075454 N150PMDurand Jennings · Evanston, ILBuilt 1970 · S/N 15072168 N150RZBhat Shaffin · Sparta, NJBuilt 1974 · S/N 15074929 N150UKMarshall Christoper E · Boise, IDBuilt 1973 · S/N A1500470 N150VTFly Vermont LLC · Swanton, VTS/N 15072813 N150WNDombert Dylan D · Navarre, FLBuilt 1973 · S/N 15075320 N150WVBlack Star Aviation LLC · Round Rock, TXBuilt 1971 · S/N 15072848

Back to Cessna 150L