AD 2007-08-07
Registered aircraft · 454
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:2007-08-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:2007-08-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:2007-08-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:2007-08-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.
N4815YAdrian Soaring Club Inc · Ypsilanti, MIN4817YQuality Aviation Inc · Marana, AZN4825YHall William B · Vincentown, NJN4827YThief River Aviation Inc · Thief River Falls, MNN4832YStohr Beuford G · Woden, IAN4838YWagner Nathan D · Dane, WIN4840YDmc Aircraft LLC · Naples, FLN4841YBlack Forest Soaring Society · Monument, CON4856YAgland Air Inc · Beaver Dam, WIN4860YAerial Banners Inc · Pembroke Pines, FLN4862YKohler Richard L · Moriarty, NMN4873YCherry Hill Aviation Inc · Freetown, INN4897YKnutson Wayne R · Tioga, NDN4898YSimmons Mark Adba · Pawcatuck, CTN4923YDenton Aerial Spraying Inc · Las Animas, CON4926YDenton Aerial Spraying Inc · Las Animas, CON4928YSpragues Aerial Spraying Inc · Courtenay, NDN4938YAerial Banners Inc · Pembroke Pines, FLN4964YFowler Larry K · Harrison, ARN4966YSchmitt Rudy · Brookshire, TXN4977YQuality Aviation Inc · Marana, AZN4983YCaprock Soaring Association · Lubbock, TXN4988YVan Kleek Steve D · Milford, IAN50TPSoar Utah Inc · Heber City, UTN54000Entropic Synergies LLC · Visalia, CAN54879Shaw Brian · Granada, CON54881Huntsville Soaring Club · Brownsboro, ALN54898Central Indiana Soaring Society · Yorktown, INN54904Quality Aviation Inc · Marana, AZN54909Soaring Society Of Dayton Inc · Waynesville, OHN54914Csa Foundation Inc · Wellington, CON54915Mohawk Soaring Club Inc · Hoosick Falls, NYN6016ZPrestenbach Kyle A · Vacherie, LAN6021ZAerial Banners Inc · Pembroke Pines, FLN6035ZAerial Banners Inc · Pembroke Pines, FLN6047ZValley Soaring Club · Middletown, NYN6049ZLockwood Shawn O · Volborg, MTN6052ZJackson Paul D · Phoenix, AZN6053ZSlack Brenda · Norfolk, VAN6058ZBlackstone Aircraft LLC · Hartselle, ALN6079ZSimmons Aviation Services LLC · Pawcatuck, CTN6112ZLowry Wilson R · Leonardtown, MDN6120ZH & H Ag Aviation Inc · New Underwood, SDN6125ZSvendsen Jon A · Wasilla, AKN6126ZKistler Stephen M · Monument, KSN6127ZSimmons Aviation Services LLC · Pawcatuck, CTN6140ZConnecticut Soaring Association Inc · New London, CTN6141ZRotor And Wing · Tioga, NDN6151ZRotor And Wing LLC · Tioga, NDN6175ZSpot-Air LLC · Burlington, TX
Back to AD 2007-08-07