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.
N6904KHolcomb Garry M · Point, TXN6904NSchaffhauser Daniel L · Garland, TXN6904UMyers Ronnie L DBA · Appling, GAN69053Aerofeather Aviation Inc · Suffolk, VAN6905DEvans Theresa K · Alexandria, MNN6905HTang Flyer LLC · Wausau, WIN6905JDouble Delta Sierra LLC · Bristol, CTN6905NZero Five November Holding Inc · Kalispell, MTN6905PMampel Gregory J · New Port Richey, FLN6905VOscar Mike Appraisal Group LLC · Greenville, SCN6905WPodeweltz Wayne L · Merrill, WIN6905ZZellers And Smith Enterprises LLC · Flowood, MSN69066Lake Elmo Aero LLC · Lake Elmo, MNN6906KWilliams Don D · Athens, ALN6906QFlorida Keys Flight Academy LLC · Marathon, FLN6906VMatthews Cheryl L · Baker City, ORN69078Central Texas College · Killeen, TXN6907BJordan Walter B · Chehalis, WAN6907NHensley Tyler · Leland, NCN6907VPounds Gregory S · Sykesville, MDN6908BMeriden Aviation Center LLC · Meriden, CTN6908KRegistration Pending · Dillingham, AKRegistration pendingN6908UPaul Michael · Fort Worth, TXN6908VForoozesh Paymon Michael · Olalla, WAN6909BKaufmann Arnold L · Davenport, IAN6909KJersey Devil Dusters LLC · Southampton, NJN6909NDevore John A C · Marion, OHN6909QHuston Lee E · Graham, WAN6909UVandivort Austin J · Strawberry Plains, TNN690ABKirkland Klayton E · College Station, TXN690BLincwings Society LLC · Austin, TXN690HAAims Community College · Greeley, CON690JTAviationmt LLC · Kalispell, MTN690LHChristiansen Aviation LLC · Wilmington, DEN690PMMiddlefield Farm And Garden Co · Middlefield, OHN690SHCorriher Mark B · Mocksville, NCN690TSMartin Tony A · Kingwood, TXN690VBruegger Traylin T · Lance Creek, WYN690ZKalisz John B · Newhall, CAN691Rice James L · Mckinney, TXN69104Giger Janice F · Weston, ORN6910DWood Robert A · Sheboygan, WIN6910JPlane Nonsense Inc · Middletown, DEN6910NThornton Michael W · Clinton, NCN6910UEmbrey Quentin S · Beaver Dam, KYN6910VLehman Aubrey M · Temple, TXN69110Zumbrun Dennis · Montz, LAN6911HHarbour Aviation LLC · Weatherford, TXN6911JJacksonville Airport Authority · Jacksonville, ILN6911KHatley Sean P · Mount Horeb, WI
Back to AD 90-04-06 R1