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 ('0630710')
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 ('0630710')
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.
N9369LNichols David M · Medford, ORN9370LLawrence Guy · Bakersfield, CAN9372LBaugh Brett J · Jonesboro, ARN9374LMcmanus Keith S · Carlisle, PAN9376LSchrick Robert B · Firth, NEN9377LLowry Joseph · Elizabethtown, ILN9378LQuigley Patrick M · Slidell, LAN9381LRyback Andrew · Ocala, FLN9382LCox Steven G · Colorado Springs, CON9383LRegistration Pending · Omaha, NERegistration pendingN9384LBethel Thomas G N · Moultonborough, NHN9386LMiller Michael C · Bullard, TXN9388LClark Edward C · Denver, COFirst renewal noticeN9398LBarlow Robert K · Lakeway, TXN9402LMacgillivray Ian Spencer · Bakersfield, CAN9403LZachary Taylor M · Queen City, TXN9404LPeak 8 Aviation LLC · Breckenridge, CON9405LVann Dudley C · Greenville, NCN9407LBowling David L · Indianapolis, INN9413LFeinstein David · Milford, CTFirst renewal noticeN9416LOjeda Kathleen · Pearland, TXN9419LDorman Zachery Ray · Mountain City, TNN9420LEddleman Russell K · Phoenix, AZN9422LGryske Kenneth R · Pinehurst, NCN9425LSiegel R J · Bayside, WIN9426LKohout John S · Terrell, TXN9427LGaiss Randolph M · Lake City, FLN9428LBarrett Lewis E II · Woodstock, GAN9430LArnason Matthias J · Portland, ORN9431LCordova Zachary · Brighton, CON9435LHubbell Aerin B · Mccordsville, INN9437LMurrell George E · Glendale, AZN9438LM & B Blue Sky LLC · Southlake, TXN9439LCheung Patrick · Boca Raton, FLN9440LLuedemann Douglas S · Brenham, TXN9444LDiller Aaron J · La Salle, CON9446LDiegoli John E · Ashland, ALN9448LCole Douglas W · Kennewick, WAN9451LWe Fly High LLC · Helena, MTN9455LNollette Joseph B · Spokane, WAN9456LGulfstream Aerospace Corp · Savannah, GAN9461LAnthonson Ronald G · Cortland, NYN9462LBrake Kevin · Mars, PAN9464LLehman Logan R · Front Royal, VAN9466LEastern Slope Aviation Academy · North Conway, NHN9467LFanego David · Cape Coral, FLN9468LGa N9468l LLC · Atlanta, GAN9469LButler Mark E · Texarkana, TXN9472LBradt Jeffrey A · Charlton, NYN9476LJohnson Nicholas J · Cantonment, FL
Back to American AA-1A