AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N61JHHobbs Christopher J · Pinson, ALN61LDBlake Lorenzo D · Wynne, ARN61LEAckerman Nile · Johnston, IAN61LHFive Star Marketing Inc · Morrisville, NCN61LTAirhart Michael · Justin, TXN61MBAllen Thomas E II · Camden, ARN61MJSnell Matthew Lea · Ackerly, TXN61NDPilot Partners LLC · Saint Augustine, FLN61PMGood Martin · Fort Defiance, VAN61RE3d Aviation LLC · Aliso Viejo, CAN61RFDumont Franck M · Chippewa Falls, WIN61RMMckenna Michael B · Lawrenceville, GAN61RVSharpe David F · Ocala, FLN61SEBase III LLC · Winnetka, ILN61TACti Aircraft Leasing LLC · Memphis, TNN61TBJay Travis · Vero Beach, FLN61TDCrick Christopher J · Guthrie, OKN61TPPalmer Blake A · Knoxville, TNN61UComanche Skye LLC · Savannah, GAN61VLKamiab Kambiz · Bonners Ferry, IDN61WDKalbfleisch Jason P · Bismarck, NDN61ZBIntegratis Inc · Carmel, CAN62000Clark Nikita C · Ontario, ORN6200RFlycarolina LLC · Charlotte, NCN6200UWhatley Equipment Co Inc · Van, TXN6200WGraves Jeffrey D · Smithville, TXN6200ZAerial Banners Inc · Pembroke Pines, FLN6201FJohnson Norman E · Ellijay, GAN6201PBrady James W · Moncure, NCFirst renewal noticeN6201WWilliam James S · Central City, NEN6201YSorenson Andrew · Pickens, SCN6202UHolmes Richard · Provo, UTN6202XBlue Sky Aviation Service LLC · Sioux Falls, SDN6203JJackman William Lee · Newman Lake, WAN6203KDeleon-Muniz Mario Antonio · Hemet, CAN6203LHolt Dennis A · Cottonwood, AZN6203NHendrickson Flying Service Inc · Rochelle, ILN6203WCoastal Valley Aviation Inc · Santa Maria, CAN6203ZKnutson Wayne R · Tioga, NDN6204ADelong Donald E · Conyers, GAN6204JFotos Kenneth J · Spring Grove, ILN6204PWisto James F · Chandler, AZN6204WTownley Bryan W · North Bend, WAN6205ADorbzeldge Air Service LLC · Bloomfield Hills, MIN6205FMonnin Cass C · East Wenatchee, WAN6205JWisconsin Aviation-Four Lakes Inc · Madison, WIN6205LMalysz Thaddeus M · Wilbraham, MAN6205PTwo Dot Aircraft Ll · Kalispell, MTN6205UAdams Claude T Jr · Palmer, AKN6205VRed Baron LLC · Middletown, DE
Back to AD 90-04-06 R1