Birmingham, AL
Registered aircraft · 216
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'AL' AND g.registrant_city = 'BIRMINGHAM' ORDER BY g.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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'AL' AND g.registrant_city = 'BIRMINGHAM' ORDER BY g.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.
N1051KMooney M20R · S/N 29-0285N105VPVan Pelt L/Van Pelt C VELOCITY-XL · S/N 3FX 020N1084XBell 206B · S/N 5170N10NLLearjet 45 · S/N 128N10UHCessna 550 · S/N 550-0925N1108CCirrus Design SR22T · S/N 2412N111ZWBeech A36 · S/N E-396N1195TBeech A36 · S/N E-629N119CJCessna 525A · S/N 525A0119N11TEEmbraer S A EMB-505 · S/N 50500081N121BKCessna 310R · S/N 310R0893N12XZCessna 140 · S/N 13182N132CTPiper PA-34-200T · S/N 34-7870179N1396ABeech V35A · S/N D-9012N140HMLearjet 45 · S/N 2103N14DWPiper PA-32RT-300T · S/N 32R-7887023N153CJCessna 525A · S/N 525A0153N1669WBeech F33A · S/N CE-392N169JHDJI AGRAS T40 · S/N 64TBL21002019NN16LVIai GULFSTREAM G150 · S/N 320N16SLSteve Lemke CHALLENGER II · S/N CH2-0292-B-0818N172SBCessna 172N · S/N 17267683N1810RCessna R182 · S/N R18200569N185MCessna A185F · S/N 18503532N1901Israel Aircraft Industries GULFSTREAM G150 · S/N 213N191VFCessna 560 · S/N 560-0627N1955HPiper PA-32R-300 · S/N 32R-7780209N1961MCessna 182P · S/N 18264506N196VAWalker James A RV-7A · S/N 70196N199PHAeronca 7AC · S/N 7AC-4395N1MQBeech 58 · S/N TH-731N2015RCessna 182G · S/N 18255215N2033BDJI AGRAS T40 · S/N 64TBL4E00200B4N205ASCirrus Design SR22T · S/N 9344N210CKSmith M R/Fann R P LEGACY 2000 · S/N L2K-148N2131TPiper PA-28R-200 · S/N 28R-7135111N216BGCessna 560XL · S/N 560-6083N217SBSportine Aviacija IR Ko LAK-17B FES MINI · S/N 021N219CHRaytheon 58 · S/N TH-1990N21MBCessna 150M · S/N 15077002N220BGTextron 560XL · S/N 560-6215N222ACBeech A36 · S/N E-1125N223MPAlexander Schleicher ASH 26 E · S/N 26253N225DCGulfstream Aerospace G-IV · S/N 1253N229DACirrus Design SR20 · S/N 2341N232TTMooney M20K · S/N 25-0448N234ELPiaggio Aero Industries P180 AVANTI II · S/N 1153N2400QCessna 182J · S/N 18257600N243AMRaytheon B200 · S/N BB-1896N247JExtra Flugzeugbau EA 300/L · S/N 1247
Back to Birmingham, AL