AD 2012-03-07
Registered aircraft · 62,071
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-07')
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-07')
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-07') 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-07') 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.
N1046BOglesby Jonathan D · Okmulgee, OKN1046XFarnham Aviation Services LLC · Ames, IAN1046ZAvery Robert K · Fort Worth, TXN10470Leary Dan P · Girdwood, AKN1047MChristiansen Aviation LLC · Wilmington, DEN1047NMccormick William R · Louisville, KYN1047VPoulter Thomas R · Chelsea, MIN1047XHuber Frank B · Maple Grove, MNN1047YDonato Deleonardis · Paulden, AZN10480Piper 66 LLC · Kirksville, MON10481Marshburn Leroy D III · Kernersville, NCN1048AUnderdahl Kirby L · Hamilton, MTN1048CPalmer Gretchen · Knoxville, TNN1048EPaul John R · Boise, IDN1048FWard Anthony · Paige, TXN1048QTaf Aerial Services LLC · Corpus Christi, TXN1048TTrotter Thomas J · Bremerton, WAN1048XLogan Colton Dean · Pagosa Springs, CON1049PLamal Thomas K · Fairbanks, AKN104AHickman John E Jr · Coronado, CAN104ACRoss Stephen D · Greenfield, OHN104AFNance David B · Quinton, VAN104BLSpiva Brett · Knoxville, TNN104BVSea Horse Sportfishing LLC · Clinton, NCN104CAMeggers Roger D · Baker, MTN104CCN104cc LLC · Fredericksburg, TXN104DMiller Charles H Jr · Cape Carteret, NCFirst renewal noticeN104DMMcalee Dennis E · Defiance, MON104EGSpitzer Helicopter LLC · Wilmington, DEN104FFPlane Fun Inc Tr Trustee · Snellville, GAN104FGWilson Conrad · Bowdon Junction, GAN104GPKline Michael S · Gypsum, CON104HYGlenn Heath · Ranger, TXN104JDJnk Equipment LLC · Deer Harbor, WAN104LCarver Clarence K Trustee · Lutz, FLN104MNCarpenter Jon Jay · Granada Hills, CAN104NPDv Aviation Inc · Brainerd, MNN104PBMountain Flight LLC · Missoula, MTN104PDBaumann James R · Muskogee, OKN104PTMacomber Donald C · Santa Ynez, CAN104RVMetz Thomas · Northwood, NDN104TCarey Daniel F · Rockville Centre, NYN104TBMclear Robert C · Rock Hill, SCN104UReed Russell M · White Salmon, WAN104VADulles Aviation Inc · Bristow, VAN104XLeider Robert G · Washoe Valley, NVN1050AMcmahan Charles B · Gakona, AKN1050RWatrous Scott A · Warrenton, VAN1051ARegistered aircraftN1051QJacobsen Gary James · Yelm, WA
Back to AD 2012-03-07