Skip to content

Registered aircraft · 189

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

N1333DBaldock Patrick M · Carleton, MIBuilt 1942 · S/N 5838 N133RGR & R Aviation Supply Inc · Scottsville, VABuilt 1940 · S/N 5363 N134QUlrich Philip J · Punta Gorda, FLBuilt 1940 · S/N 5484 N14085Morozowsky Anthony M · Zanesville, OHBuilt 1942 · S/N 5836 N151LPPietsch Warren A · Minot, NDS/N 5824 N152EMorozowsky John S · Zanesville, OHBuilt 1940 · S/N 5530 N158EFerris Lyle C · Antioch, ILBuilt 1940 · S/N 5577 N164Lcs Energy Inc · Dover, DEBuilt 1940 · S/N 5583 N173EWaco Partners LLC · Dunkirk, NYS/N 5592 N180GDKimball Ronald C · Washington, INBuilt 1941 · S/N 5599 N184ECiabattoni Joseph L · Upland, CABuilt 1941 · S/N 5603 N185VKing John D · Midland, VABuilt 1941 · S/N 5604 N20971Baldwin David M Jr · Port Orange, FLBuilt 1940 · S/N 5317 N20973Four Stars Four Bars Aeromotive LLC · Fairbanks, AKS/N 5319 N20979Dmb Aircraft Inc · Edgartown, MABuilt 1940 · S/N 5326 N219Ytp-14 LLC · Ocala, FLBuilt 1939 · S/N 5302 N226EPalm Springs Air Museum Inc · Palm Springs, CABuilt 1939 · S/N 5309 N2291King John D · Midland, VABuilt 1939 · S/N 5312 N2369QFranklin Kyle A · Ruidoso, NMBuilt 1940 · S/N 5387 N247TGGummer Thomas E · Anchorage, AKBuilt 1941 · S/N 5611 N29300Aeh Flying Inc · Cincinnati, OHBuilt 1940 · S/N 5327 N29301Horst Aviation LLC · New Holland, PABuilt 1940 · S/N 5328 N29303Roberts Marc · Thomasville, PABuilt 1949 · S/N 5330 N29309Mcgrath Joel M · Nine Mile Falls, WABuilt 1940 · S/N 5336 N29312Wenglarz Maxwell D · San Pierre, INS/N 5649 N29322Flaglor Thomas R · Mosheim, TNS/N 5349 N29323Rare Aircraft Ltd · Faribault, MNS/N 5350 N29324Collings Foundation Inc DBA · Hudson, MABuilt 1940 · S/N 5351 N29327Parker O'Malley Corporation · Chatham, NYBuilt 1940 · S/N 5354 N29328Miss Daisy LLC · Helena, MTBuilt 1940 · S/N 5355 N29337Vanderbeek Robert K · Plainfield, ILBuilt 1940 · S/N 5364 N29338Mccoy Randy L · Winnemucca, NVBuilt 1940 · S/N 5365 N29352Mccoy Randy L · Winnemucca, NVBuilt 1940 · S/N 5379 N29353Simply Living LLC · Fort Myers, FLBuilt 1940 · S/N 5380 N29355James Stanley J · Williamson, GABuilt 1940 · S/N 5382 N29357Burns Steven M · North Hampton, NHS/N 5384 N29364Mills Air Service Inc · Marstons Mills, MABuilt 1940 · S/N 5391 N29365Wiemer Karl J · Norwalk, CTS/N 5392 N29368Marden Thomas C · Erwinna, PABuilt 1940 · S/N 5395 N29901Blue Sky Adventures LLC · Hanover, PABuilt 1940 · S/N 5398 N29902N29902 LLC · Sheridan, ARBuilt 1940 · S/N 5399 N29905Silver Cloud USA LLC · Ellicottville, NYBuilt 1940 · S/N 5402 N29908Barnes Rodney E · Iron Ridge, WIBuilt 1940 · S/N 5405 N29909Hotel Charlie LLC · Lewes, DEBuilt 1942 · S/N 5406 N29911Se2quel Partners LLC · Pleasanton, CABuilt 1940 · S/N 5408 N29919Scheibe Mark E · Lakeville, OHBuilt 1940 · S/N 5416 N29923Btb Ltd · Wilmington, DEBuilt 1940 · S/N 5420 N29925Scheibe Mark E · Lakeville, OHBuilt 1940 · S/N 5422 N29926Ifly High LLC · Phoenix, AZS/N 5423 N29927Keller James E · Canton, OHBuilt 1940 · S/N 5424

Back to Waco UPF-7