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.
N6591EWay Robert Louis · Morristown, AZN6591PRichardson Jeffrey S · Grove City, PAN65923Noste Erik · Mount Vernon, WAN6592JWorland Flying Club LLC · Worland, WYN6592LPruszenski Stanley F · Anchorage, AKN6592QCd Aircraft LLC · Signal Hill, CAN6592UEriksson Trent A · Waterford, MIN6592WChait Braeden Abraham · Vancouver, WAN6593AHard Luck Aviation LLC · Tok, AKN6593JRed Tail Scholarship Foundation · Tuskegee, ALN6593PAshenhurst Thane T · Wheatland, WYN6593RZwicker Brian · Richmond Hill, GAN65940Bavarian Barnstormers 2 Inc · North Fort Myers, FLNon-citizen corporation, flight hours not reportedN6594JHub City Aviation Academy LLC · Lubbock, TXN6594PBoyd Larry C · Wellton, AZN6594RBig Bend Community College · Moses Lake, WAN6595G95 Golf Inc · Greenwood, INN6595KMr B Aviation LLC · Sag Harbor, NYN6595RBig Bend Community College · Moses Lake, WAN65965Legends Air Center LLC · Bentonville, ARN6596DMcdonald Kevin K · Anchorage, AKN6596PAce Aircraft Leasing Inc · Nazareth, PAN6596ULipper Charles S Pers Rep · Stone Mountain, GAFirst renewal noticeN6596WN6596w LLC · Derby, KSN6596XRingen Marvin O · Beaverton, ORN6597GOff Airport Adventures LLC · Saint David, AZN6597UAldo Leonardi · Woodland, CAN6598JThatcher Bruce Lyall · Shorewood, MNN6598UAdams Michael S · Huntsville, ALN65994Christiansen Aviation LLC · Wilmington, DEN6599DBlue Shield Aviation LLC · Saint Petersburg, FLN6599JCormack Matthew S · Chandler, AZN659APiper Archer Three LLC · Wilmington, DEN659DEEisenhauer Dwight · Lehighton, PAN659FLHudacko Daniel M · Saint Cloud, FLFirst renewal noticeN659FTFlorida Institute Of Technology Inc · Melbourne, FLN659GJHolmes Jonathan Charles · Mount Pleasant, SCN659HCHowlett Corey · Wasilla, AKN659KWWoods Kevin E · Albrightsville, PAN659SPChristiansen Aviation LLC · Wilmington, DEN659TLLubonovic Thomas M · New Carlisle, OHN65ATRhodes Steven D · Anchorage, AKN65BHNorthern Aviation LLC · Wauseon, OHN65BJRamage Calvin L · Columbia, MON65BMVolatilis LLC · Wilmington, DEN65CDTeva Services LLC · Land O Lakes, FLN65CNJohnston Charles Wc Jr · Newfield, NJN65CSChallans Robert F · Hesston, KSN65DHCrocker John M · El Dorado, CAN65DPPilawski Darren · Spring Hill, FL
Back to AD 90-04-06 R1