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 ('2071816')
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 ('2071816')
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.
N4069JFdp Productions LLC · Atlanta, GAN4070JClark Philip M · Caldwell, OHN4071JMilhous Walter L · Carmichael, CAN4075JB&R Aircraft LLC · Wadsworth, OHN4086JBell Robert A Jr · Scotland Neck, NCN4088JLampasona Brendan T · Citrus Springs, FLN4093JGarcia Joseph Donald · Okeana, OHN4094JSquires Janis R · Amherst, OHN4095JParks Richard C · Salem, MON4098JFrench Darrell L · Easton, MDN431DKrause Derris O · Cumberland, MDN4441KWeaver Aircraft Co · Carson City, NVN457AESahni Irvin K · Seguin, TXN4600XTwo Dot Aircraft LLC · Kalispell, MTN4601XMast Aviation LLC · South Boston, VAN4606XThird Coast Aircraft LLC · Mobile, ALN4607XVeldhuizen Richard B · Jesup, GAN4614XEdwards Dustin M · Marion, ILN4616XDumanian Bruce C · Savannah, NYN4618XEnochs Richard L · Hartford, INN4620XWilliams David R · Havre, MTN4621XWidby David A · Anchorage, AKN4628XWilson Daniel T · Bandon, ORN4632XGerstemeier Bernard A · Advance, NCN4634XSorg Daniel T · Columbus, INN4638XHoward David R · Oconomowoc, WIN4639XCjs Aviation Consulting LLC · Phoenix, AZN4640XStern Roger A · Kearny, AZN4643XTaylor Aaron B · Leander, KYN4648XRipp Patrick L · Mineral Point, WIN4650XBurt Compton Enterprises Inc · Marfa, TXN4653XRankin Kevin · Maryville, MON4654XMurray Dale W · East Wenatchee, WAN4655XJp Aero Holdings Inc · Carson City, NVN4657XVan Buskirk Samuel Victor · Valdez, AKFirst renewal noticeN4660XRegistered aircraftN4661XDresden Leasing LLC · Sheridan, WYN46660Knutson Wayne R · Thompson, NDFirst renewal noticeN4666XHolmes Joseph E · Cherry Valley, CAN4669XLwl Aero LLC · Saint George, UTN4672XAmerican Piston Domestic LLC · Lonsdale, MNN4673XRegistration Pending · Bloomingdale, OHRegistration pendingN4674XSaunders Christopher · Lehighton, PAN4675XBlalock Merrel K III · Mayflower, ARN4677XBaird Harvey L · Sharon, OKFirst renewal noticeN4679XVentura Joel · Andover, MAN4685XFite Robert G · Brookings, SDN4688XMather Paul L · Saint Elmo, ALN4689XGerard Aircraft Inc · Johnson, KSN4692XMelvin Jet · Bedford, IN
Back to Cessna 150G