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.
N6405LKoster Mark W · Amarillo, TXN6407LVetter Johnathon A · Moundridge, KSFirst renewal noticeN6409LKirkpatrick Joshua · Cleburne, TXN6412LRichie John W · Murfreesboro, TNN6413LBoykin Dennis B IV · Leesburg, VAN6416LRegistration Pending · Crosby, MNRegistration pendingN6419LHaag Jay E · Mason City, IAN6423LSrk Aero LLC · Magnolia, TXN6424LCm & Te LLC · Williston, FLN6427LOtt Todd D · Craigmont, IDN6429LMcpherson Joshua R · Oviedo, FLN6430LSale Reported · Maysville, KYSale reportedN6432LBlount Charles L Sr · Gentry, ARN6434LBiddlingmeier Donald W · Grosse Pointe Wood, MIN6435LStutts Jody D · Iuka, MSN6437LMartz G Rooney · Frederick, MDN6439LTuttle Scott R · Ogden, IAN6440LMcclure Ron C · Lovell, WYN6446LPradhan Anis · Torrance, CAN678BBDalton Raymond O Trustee · Nashville, TNN6FARichards Donald D Jr · Cookeville, TNN706LGRegistered aircraftN71YYAgl Flight LLC · Callahan, FLN7252LForney Luke N · David City, NEN7255LHall Travis J · Dayton, TNN7256LRegistration Pending · Fair Bluff, NCRegistration pendingN7259LDella Ripa Vincenzo · Newbury Park, CAN7260LMincy Aviation LLC · Manistee, MIN7264LLarson Aircraft LLC · Sandy, UTN7265LGulfstream Aerospace Corp · Savannah, GAN7268LFletchair Inc · Comfort, TXN72PMAircraft & Aviation Professionals LLC · Coldwater, MIN73DCTwin Aviation LLC · Liberty Hill, TXN7CBrennan Joseph · Shirley, NYN89CSlough Samuel Herbert · Flora, MSN9205LJarog Terence A · Denton, TXN9206LHohner Jack B · Spokane Valley, WAN9207LLindquist Steve · Granite Falls, MNN9210LMid Atlantic Air Museum · Reading, PAN9212LSmith Randall G · Salem, ORN9215LDipietro Ian · Westfield, MAN9216LLawrence Guy A · Bakersfield, CAN9219LHart Gene E · Ridgecrest, CAN9222LTyler Timothy C · Wyoming, OHN9223LHogan Fredrick C · Oviedo, FLN9224LAnalytical Technologies Inc · Miami, FLN9225LTerry Mark B · Henderson, NCN9232LLuquette Harley M · Abbeville, LAN9233LGreen Samuel B · Clifton Park, NYN9235LKidd Jeffrey A · Norcross, GA
Back to American AA-1A