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.
N8022GAaron Arthur Harrison · Gold River, CAN8022NNiendorf John R · Friday Harbor, WAN8022RBlackwing Aviation LLC · Flower Mound, TXN8022WDean Newton Aviation LLC · Whitehouse Station, NJN8022YDanis Paul A · Woodinville, WAN80230Fly Nh Aviation LLC · Bow, NHN80238Hess Garrett J · Fullerton, CAN80239Borreson Anthony · Mariposa, CAN8023DSanchez Pascual G · Pantego, NCN8023NStafford Craig A · Tempe, AZN8023WHydroplane Ltd · Sherman Oaks, CAN80246Lincoln Skyways Inc · Lincoln, CAN80248Mtm Deland LLC · Deland, FLN8024GRedwing Aviation LLC · San Antonio, TXN8024NAll American Aviation Services Inc · Fayetteville, NCN8025Buergel Sandra J · East Aurora, NYN80251Harrison Social Flites Inc · Harrison, OHN80254On Glideslope LLC · Middletown, DEFirst renewal noticeN8025CLaabs Fran C · Ames, IAN8025EMission Aviation Fellowship · Nampa, IDN8025GN8025g C177rg LLC · Jeffersonville, INN8025N8025n Flyers Ltd · Monsey, NYN8025RGaboury Michael J · Two Harbors, MNN8025WMann Nicholas Lee · Grand Canyon, AZN8025XCivil Aviation Leasing Ltd · Wilmington, DEN80263Breton Yacht Co LLC · Schenectady, NYN80267Bisson James H · Piercefield, NYN8026CWyatt Gaylon J · Pineville, ARN8026NJenkins Carl S · Muncy, PAN8026PMontgomery Investments Inc · Washington, UTN8026QInternational Fun Place Hangar 32 LLC · Laughlin, NVN8026YCaillouet Andre E Jr · Houma, LAN80270Fisher Robert · Shoreacres, TXN80277Usaeroflight LLC · Greenville, SCN80278Baur Ronald N · Gig Harbor, WAN80279Tueller John D · Spring Creek, NVN8027FCyganski David · Palm Beach Gardens, FLN8027GBas Part Sales LLC · Greeley, CON8027YGreek Housing Services Corp · Port Matilda, PAN80282Nguyen Nhu-An T · Bethesda, MDN80283Barxbar Aviation LLC · Mesa, AZN80287Campbell Frederick G · Rigby, IDN8028CLisk Justin T · Rhodes, IAN8028GAndersen Timothy R · Elizabeth City, NCN8028RBorgers Thomas R · Palmyra, NJN8029Sorenson Tyler D · Bountiful, UTN80291Davidson Doug W · Newcastle, WAN80295Legacy Skies Aviation LLC · Rogers, ARN80298N80298 LLC · Miami, FLN80299Mountain Air Aviation Inc · Bethesda, MD
Back to AD 90-04-06 R1