AD 2007-04-19 R1
Registered aircraft · 108,434
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-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N506HSChordwise Aviation LLC · Sedro Woolley, WAN506JMAims Community College · Greeley, CON506KGLone Star Land & Cattle Co · Houston, TXN506MRegistered aircraftN506PCShettlesworth Ryan C · Bloomington, INN506RBChristiansen Aviation LLC · Wilmington, DEN506RVMelillo Peter J · Huntington Station, NYN506SPHenrie Aviation LLC · Fairfield, NJN506XLyons Leasing LLC · Zionsville, INN506XCMark A Hall LLC · Sunman, INN506YZR&R Gray Equipment & Cattle LLC · Enid, OKN5070GSky Fusion II LLC · Atlanta, GAN5070JCrc Properties Inc · Coto Laurel, PRN5070KSmith Alice B · Escondido, CAN5070LHayden Daniel · North Pole, AKN5070NWilkinson Dane W · Morgan, UTN5070UO'Donnell Paul E · Schuylerville, NYN5070VRiney Nicholas K · Prescott, AZN5070XN566rm LLC · Wilsonville, ORN5071CWalker Rhan E · Pleasant Hill, MON5071DAcmx LLC · Cedar Rapids, IAN5071GRowland Dusters LLC · Raymondville, TXN5071HFosse David K · Carbondale, ILN5071JSol Aerial Surveys LLC · Las Vegas, NVN5071KSkyview LLC · De Smet, SDN5071LHill Karl D · Igiugig, AKN5071WWallace Madison F · Thomasville, NCN5071YFletchers Aviation LLC · Mason, NHN5072CThomas Robert Allan Jr · Phoenix, AZN5072HRiebeling Eric Herbert · Reno, NVN5072PCappurccini Alfred II · Pittsburgh, PAN5072UStopka Alexis L · Belgrade, MTFirst renewal noticeN5072VPolski Randy B · Baltimore, MDN5072WHurst Randall S · Altus, ARN50731Datema Steven K · Susanville, CAN50733Howlett Brian A · Clarkston, WAN5073CInternational Air Services Inc Trustee · Carson City, NVN5073HElite Planes LLC · Menifee, CAN5073JYork Avery C III · Crossville, TNN5073NPavco Inc · Gig Harbor, WAN5073RMckenna Brothers Aircraft LLC · Anchorage, AKN5073UMutha Fokker Aviation LLC · Wilmington, DEN5073VSeaton Brad S · Cache, OKN5073WPerkins Joel · Senoia, GAN5073YLone Star Flight Museum · Houston, TXN5074ATherp Todd J · Ashton, IDN5074BMehrhoff Stanley E · Prairie Home, MON5074DAhumada George · Palmer, AKN5074HRollins Thomas M · Salt Lake City, UTN5074MFaddis Ray K · Kingwood, TX
Back to AD 2007-04-19 R1