AD 2022-13-07
Registered aircraft · 65
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:2022-13-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:2022-13-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:2022-13-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:2022-13-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.
N101VCAgusa Pc Inc · Wilmington, DEN104DSStanley Dean · Conroe, TXN104MSHase Aviation LLC · Tomball, TXN1268YRegistered aircraftAssigned (import), pending cancellationN128AGBenua Susan · Ocala, FLN153AGAgusa Pc Inc · Wilmington, DEN157PGyro-Ventures LLC · Phoenix, AZN15SKKelly Stacy L · N Richland Hills, TXN169DSHorseshoe Air LLC · Fairfield, TXN210AGCouch Kelly P · Livingston, MTN215DGAgusa Pc Inc · Wilmington, DEN216PMBolinger Andy L · La Follette, TNN2217VA I Marketing Inc · Idaho Falls, IDN222DMOrchard Lane LLC · Kalispell, MTN233AGPrintz Darren Kent · Springdale, ARN24ETReid Kevin · Clarkrange, TNN255AGVoth Stephen R · Dequincy, LAN279ATMance Steven J · Poughkeepsie, NYN28TEGrover Kirk A · Prairieville, LAN297AGAgusa Pc Inc · Wilmington, DEN321EWWiles Edward · Naperville, ILN369RDDaniels Ray · Chicago, ILN383AGOnstott Brent O · Burkburnett, TXN40PATrull Ethan E · Highland Park, ILN411AGKlahr Richard A · Boyertown, PAN433LABlue Shark LLC · Wilmington, DEN44ALShultz Robert F · Spring, TXN452AGScurto Michael J · Pomona, CAN454JDDenooyer James · Albany, NYN457KWWallingford Kenneth H · Lake City, MIN47PBExtreme Air LLC · Santa Barbara, CAN493AGSnyder Robert L · Stevensville, MDN50RWClassic Helicopter Corp · Auburn, WAN533EVHorizon Aircraft Leasing LLC · Holland, MIN535RLLaird Robert T · New Waverly, TXN542AGSpinning Feather LLC · Dana Point, CAN612AGAgusa Pc Inc · Wilmington, DEN612MWN612mw LLC · Mesa, AZN613AGAgusa Pc Inc · Wilmington, DEN615MWGarner L Michele Trustee · Nashville, TNN621BHDiaz Javier · Harrison, NYN647CHHarrison Charles L · Vicksburg, MSN64RJJohnson Robin · Boulder, CON656AGAgusa Pc Inc · Wilmington, DEN658AGCaptain Lew Charter LLC · Ocala, FLN689TCPatton Phillip F · Gold Hill, NCN6920ATeeter LLC · Kalispell, MTN718KPDessert Fish Aviation LLC · Queen Creek, AZN726CAKuperman David B · Chico, CAN743LDGyroaviation LLC · Navarre, FL
Back to AD 2022-13-07