AD 2012-03-06
Registered aircraft · 69,559
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-03-06')
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-03-06')
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-03-06') 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-03-06') 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.
N10222Willard Gregory M · Bonita Springs, FLN1022FGoodfellow Malcolm D · Seattle, WAN1022UCivil Precast Corp · Ridgeland, MSN1022XLeggett Air LLC · Cairo, GAN1023FWinter Karl · Litchfield Park, AZN1023WGoldeagle Flyers Inc · San Jose, CAN1024Calgonaire LLC · Seminole, TXN10242Alexander Holding Services Inc · Newark, DEFirst renewal noticeN1024LSouthern Aircraft Consultancy Inc Trustee · Casper, WYN1024NSolomon Jeremy M · Somerset, NJN1024TBarnwell John Randel · Conroe, TXN1024U24u Aviation LLC · Wilmington, DEN1024ZAqua Men Service LLC · Temple, GAN1025NGood Aviation LLC · Oshkosh, WIN1025VAviation Partners LLC · Highlands Ranch, CON1025WBancroft Maurice J · Rio, WIN10262Davoli Third Family Limited Partnership · Lighthouse Point, FLFirst renewal noticeN1026ASouthern Aircraft Consultancy Inc Trustee · Casper, WYN1026CMooney Howard James Jr · Lake Wales, FLN1026FDeramus Eugene T · Garden Ridge, TXN1026JRodriguez Luis Jr · Columbus, GAN1026TEdens Erik · Scottsdale, AZN1026UMooneylust LLC · Springfield, MON1027CFacchiano Vincent R · Belvidere, ILN1027DRobins Jack S · Saint Charles, IDN1027FFilarski Darryl M · Grosse Ile, MIN1027TEye Candy Aircraft LLC · Jacksonville, FLN1028FLunoe Leif C · Anchorage, AKN1028GCreed Brian H · Fredericksburg, VAN1028RGarner Donald G · Greeley, CON1028WArt Air Partners LLC · Louisburg, NCN1029MHarris Charles T Trustee · Thousand Oaks, CAN1029TThomson Heath · Portola Valley, CAN1029XBaden Frederick Richard · Mc Arthur, OHN102AKRegistered aircraftN102ARValiair Limited Co Trustee · Casper, WYN102BMeyjes Gijsbert Posthumus · Cadillac, MIN102BEEbers Vincent A · Wellsville, MON102BNDelta State University · Cleveland, MSN102BROtv Leasing · Bristow, VAFirst renewal noticeN102CCPj Squared LLC · San Antonio, TXN102CDSch Aviation Inc Trustee · Sporle Kings LynnN102CJJordan River Aviation LLC · Madisonville, KYN102DLP & G Trading Co Inc · Trenton, NJN102DWFlyboy Aviation LLC · Memphis, TNN102EASteves Atv Services Inc · Oceano, CAN102EREmbry Riddle Aeronautical University · Daytona Beach, FLN102EXWoods Farrell T · Hudson, NHN102FAMedic Choppers LLC · Springdale, ARN102FMRegistered aircraft
Back to AD 2012-03-06