AD 2012-05-09
Registered aircraft · 6,155
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2012-05-09')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-05-09')
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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2012-05-09') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-05-09') 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.
N1017GAustin Byrum Andrew C · Rogers, ARN1017LTop Gun Aviation Inc · Quinnesec, MIN1017MOstroff Nathaniel S · Summerland Key, FLN1018CSotek LLC · Cheyenne, WYN1018MWilliams Arthur L · Amherst, OHN1018VHack Mark A · Floyds Knobs, INN10194N10194 Aviation LLC · Pleasant Hill, CAN1019CHunter James A · Elizabeth City, NCN1019ZJb Air LLC · Lindsay, OKN101DXPatierno David M · Templeton, CAN101ECAtkinson Justin Shane · Fairbanks, AKN101KUBarton Bruce R · Richmond, KYN101MURed Bird And Outlaw LLC · Schertz, TXN101TLojek Donald W · Boise, IDN101UKInternational Air Services Inc Trustee · Carson City, NVN1020AIrving Donald J · Deland, FLN1021KVranjes Miron · Mercer Island, WAN1021URegistered aircraftN1022UCivil Precast Corp · Ridgeland, MSN1024CLarsen Johannes · Sterling, MAN1026ASouthern Aircraft Consultancy Inc Trustee · Casper, WYN1026CMooney Howard James Jr · Lake Wales, FLN1026FDeramus Eugene T · Garden Ridge, TXN1026NMartin Jonathan W · Carnesville, GAN1026UMooneylust LLC · Springfield, MON1027TEye Candy Aircraft LLC · Jacksonville, FLN1029BStonewall Aviation LLC · Stillwater, OKN1029MHarris Charles T Trustee · Thousand Oaks, CAN102ATEpling Bryan J · Upper Arlington, OHN102PLLenker Mark R · Grand Prairie, TXN102PTNion LLC · New Century, KSN102TNTailwinds And Blue Skies LLC · Wilmington, DEN102YMKern Jason S Trustee · New Braunfels, TXN1030RThomas Leasing Enterprise LLC · Troy, MIN1031RKeller Paul M · Sanford, NCN1032XSunrise Aviation Inc Trustee · Wilmington, DEN1032ZHoffman Curtis A · Marlborough, MAN1033QKuhn Marcus J · Madison, WIN1034SSchlueter Jeffrey · Fernandina Beach, FLN1035NHiggins Michael S · Palatine, ILN10368S-A Clark Aviation LLC · Fort Smith, ARN1036RYork Aviation LLC · Asheboro, NCN1036USandor Pethes · Terre Haute, INN1038WMulrooney Brian P · Minnetonka, MNN1039BG & M Aviation LLC · Kokomo, INN1039KMorris Eric K · Strasburg, VAN1039SJohnson Robert E Jr · Southport, NCN103DXThornton Aaron Dewayne · Lubbock, TXN103PTAvion Guy LLC · Baton Rouge, LAN103TNArthur Lee E · Spring, TX
Back to AD 2012-05-09